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
24509 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 some major differences between triggers and stored procedures?

980

What is the contrast amongst drop and truncate?

1079

Explain important index characteristics?

1080

What are the properties of the relational tables?

928

What is user defined stored procedures?

993

List the different types of joins?

1060

How would you choose between a clustered and a non-clustered index?

1020

What are the new features of sql server 2012 reporting service?

141

How to remove duplicate rows from table?

1313

what are the different types of SSRS reports?

160

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1066

What is a unique index?

974

What are rows and columns?

1066

When to use Inner join & when to use subquery?

1238

What are distributed partitioned views?

1137