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

How the authentication mode can be changed?

1076

What is use of except clause? How it differs from not in clause?

971

What are the default system databases in sql server 2000?

962

How do I shrink an ldf file?

932

what is the information that can be stored inside a bit column? : Sql server database administration

902

When should you use an instead of trigger?

918

How can you check the level of fragmentation on a table?

986

How can you control the amount of free space in your index pages?

1010

How to make conditional sum in ssrs?

173

Is the log file is a part of file group?

975

Is sql server a database?

924

Please explain go command in sql server?

991

What is primary key, unique key, and foreign key?

916

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

998

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1012