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 a not null constraint?
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 ?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What are parameterized reports? What are cascading parameters in ssrs reports?
How much memory that we are using in Logshipping Concept?
How much is a sql server license?
How to create a login account in ms sql server to access the database engine using "create login" statements?
What is self join in sql server joins?
What are the drawbacks of reporting in ssrs?
What is db stored procedure?
how you can list all the tables in a database?
How to create a new schema in a database?
What is an sql server agent?
What are the different types of sub-queries?
What is the difference between stored procedure and user defined functions?