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
24309 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

Can a table have 2 primary keys?

987

What is difference between createstatement and preparedstatement?

1104

What is the contrast between sql and pl/sql?

1150

How do I find sql server instance name?

967

What are the advantages of user defined function?

987

Explain concepts of analysis services?

966

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

961

Is candidate a key?

957

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1938

What program is used to store the data source file?

968

What is data compression?

1016

What is the need for indexing?

955

what are constraints? Explain different types of constraints? : Sql server database administration

994

What are the encryption mechanisms in sql server?

1033

What are the approximate numeric data types?

945