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


Please Help Members By Posting Answers For Below Questions

How to set database to be read_only in ms sql server?

721


How to download and install microsoft .net framework version 2.0?

748


How does a profiler work?

664


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?

766


What are user defined functions in ms sql server?

683






Can you import Microsoft Excel data to SSRS?

111


What is the datatype of rowid?

666


Explain subquery and state its properties?

706


What is acid db?

671


How can a database be repaired?

730


What are the security related catalog views? : sql server security

703


Tell me what is sql profiler?

794


What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

766


How to access the deleted record of an event?

745


What command is used to create a database in the sql server and how?

832