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

What is ddl and dml commands?

964

Why use “pivot” in sql server?

1191

What are the requirements on sql server network connections?

1047

Explain raiserror in sql server?

1083

Explain the steps to use transact-sql cursor?

1171

What is data source object?

1081

What is triggers and stored procedures?

999

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

1005

What is meant by indexing?

1096

What are the different ways you can create databases in sql server?

1161

Explain the third normal form(3nf)?

992

What options are available to audit login activity? : sql server security

1204

How to create an index on a view?

1151

What are the basic functions for master, msdb, model, tempdb databases?

1100

Can a rule be bound to any column of any data type?

1031