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

What is a not null constraint?

598


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

1557


Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

558


What are parameterized reports? What are cascading parameters in ssrs reports?

100


How much memory that we are using in Logshipping Concept?

1368






How much is a sql server license?

510


How to create a login account in ms sql server to access the database engine using "create login" statements?

573


What is self join in sql server joins?

562


What are the drawbacks of reporting in ssrs?

108


What is db stored procedure?

469


how you can list all the tables in a database?

526


How to create a new schema in a database?

555


What is an sql server agent?

549


What are the different types of sub-queries?

600


What is the difference between stored procedure and user defined functions?

629