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
How to set database to be read_only in ms sql server?
How to download and install microsoft .net framework version 2.0?
How does a profiler work?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What are user defined functions in ms sql server?
Can you import Microsoft Excel data to SSRS?
What is the datatype of rowid?
Explain subquery and state its properties?
What is acid db?
How can a database be repaired?
What are the security related catalog views? : sql server security
Tell me what is sql profiler?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
How to access the deleted record of an event?
What command is used to create a database in the sql server and how?