How can you get @@error and @@rowcount at the same time?
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 are the purposes and advantages stored procedure?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What part does database design plays a role in performance of an sql server-based application?
Please explain go command in sql server?
How to connect of datebase with sql express.?
What is local temp table?
How raid can influence database performance?
What are distinctive joins find as a part of sql?
How to enable tcp/ip protocol on a sql server?
What is change data capture (cdc) in sql server 2008?
What are the recovery models for a database?
How to convert numeric values to integers in ms sql server?
What is row-level compre?
When would you use the stored procedures or functions?
how can a database be repaired? : Sql server administration