SELECT @RC = @@ROWCOUNT SELECT @ER = @@ERROR if we use above statements

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

Question Posted / laxman

9 Answers
24254 Views
I also Faced
E-Mail Answers

Answer Posted / laxman

SELECT @RC = @@ROWCOUNT
SELECT @ER = @@ERROR
if we use above statements then @@error will be reset with
0.
i think right one is

select @er=@@error,@rc=@@rowcount

Is This Answer Correct ?

31 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

List the various tools available for performance tuning?

885

What is the difference between the application object and session object?

1058

What is a unique key constraint?

1022

Explain an automatic checkpoint

965

What is SubQuery in SQL Server 2008

1015

What does select 1 mean?

919

What are the types of table?

978

What is data mart? : sql server analysis services, ssas

1047

How to locate and take substrings with charindex() and substring() functions?

1010

Explain identity in sql server?

997

What are policy management terms?

981

Is sql server free?

911

How to create percentile function?

151

What are the advantages of log shipping?

988

What is use of dbcc commands?

1058