DECLARE @RC int DECLARE @ER int INSERT INTO T(Cal1,Col2..) SELECT ColX

How can you get @@error and @@rowcount at the same time?

Question Posted / ramakrishna

Answer Posted / ramakrishna

DECLARE @RC int
DECLARE @ER int

INSERT INTO T(Cal1,Col2..)
SELECT ColX,ColY..
FROM T1

SELECT @RC = @@ROWCOUNT
SELECT @ER = @@ERROR

Is This Answer Correct ?

3 Yes

16 No

Please Help Members By Posting Answers For Below Questions

What different steps will a sql server developer take to secure sql server?

1039

How to create a user name in a database?

1103

Explain syntax for dropping triggers?

969

What are different types of raid levels?

1238

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1960

List down some advantages of sql stored procedure?

1016

Define Wed Edition in SQL Azure?

102

What is deploy, process and build? : sql server analysis services, ssas

1156

Explain some stored procedure creating best practices or guidelines?

1005

How to enter unicode character string literals in ms sql server?

1124

How to maintain a fill factor in existing indexes?

1057

What are the restraints imposed on the table design by a merge replication?

1094

How to retrieve field values using mssql_result()?

1419

What are the advantages dts has over bcp?

1051

What is an identity?

1079