How can you get @@error and @@rowcount at the same time?
- 9 Answers
- 22765 Views
- I also Faced
- E-Mail Answers
Answer Posted / binoo tiku
@@error variable shows the error number of the last
T-SQL error
@@rowcount variable gives the number of rows affected by
the most recent SQL statements.
| Is This Answer Correct ? | 9 Yes | 7 No |
Post New Answer View All Answers
What is a primary key?
How to execute a sql statement using mssql_query()?
what are the three command line utilities and what are their primary functions?
What is merge?
What is normalization? Explain different forms of normalization?
How to transfer data from a cursor to variables with a "fetch" statement?
Why main is user defined function?
Does a sql server 2005 select statement require a from?
How to run sql server 2005 books online on your local system?
what is a transaction? : Sql server database administration
What is difference between drop truncate and delete?
What is the beast way to write CTE in SQL Server ?
Explain sql delete command?
Why do we need different type of parameter?
What is the difference between primary key and unique constraints?
