How can you get @@error and @@rowcount at the same time?
Answer Posted / raji
@@error - displays the error number of last T-Sql statement
@@rowcount - displays the total row count of last T-Sql
statement
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is de-normalization in sql database administration? Give examples?
What is user-defined inline table-valued function?
What are advantages of ssrs or why we should use ssrs?
What is cursors? And what are the different types of cursor?
What program is used to store the data source file?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
Explain cursor as data base object?
What are the requirements to use odbc connections in php scripts?
List few advantages of stored procedure.
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is the difference between ddl,dml and dcl commands?
What do you understand by hotfixes and patches in sql server?
What is ssrs?
What are the difference between “where” and “having” clause in sql server?
What is sql or structured query language?