How can you get @@error and @@rowcount at the same time?
Answer Posted / yjreddy
select @@ROWCOUNT
it will give the no of rows affected by last sql statement
select @@ERROR
it will display the error number for last sql statement
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is transaction server consistency?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
Does the unique constraint create an index?
Why de-normalization required?
Will the writetext statement activate a trigger?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
Tell me what is a linked server?
What is the difference between update lock and exclusive lock?
What is difference between unique and primary key?
What are the general features of sql server management studio? : sql server management studio
What are system databases in ms sql server?
What is “asynchronous” communication in sql server service broker?
Explain different backup plans?
Explain primary key and foreign key constraints?
Explain what is meant by replication of database?