SELECT @@Rowcount as rwCount, @@Error as Er

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

Question Posted / gunasekaran k.j

Answer Posted / gunasekaran k.j

Is This Answer Correct ?

15 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How will you decide the active and passive nodes?

1069

What is the difference between migration and upgradation in sql server?

1037

Explain about merge replications?

963

What is the need for group functions in sql?

1006

How to create a dynamic cursor with the dynamic option?

968

What is user-defined function?

912

What are cursors stored procedures and triggers?

934

What is self join in sql server joins?

961

What is nested transaction?

1041

please differentiate between delete and truncate?

941

How to run sql server 2005 books online on your local system?

917

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

918

How do I start sql server 2016?

856

Can we use where clause with group by?

855

which table keeps the locking information? : Sql server administration

1010