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

Answer Posted / gunasekaran k.j

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

Is This Answer Correct ?    15 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by authentication modes in sql server?

611


What does the on delete cascade option do?

556


User wants only to display only pdf as export option in report manager. How to achieve this?

173


What is difference between materialized view and view?

494


What is openrowset sql server?

522






How to delete duplicate rows?

555


can a table be moved to different filegroup? : Sql server administration

548


How to copy data from one table to another table?

546


What is the use of group by clause?

531


What is extended stored procedures?

571


How to create an index on an existing table in ms sql server?

499


What are sql server procedures?

551


What is merge join?

578


Explain system views?

583


How do I find information about the install locations for the various instances running on a computer?

556