How can you get @@error and @@rowcount at the same time?
Answer Posted / binoo tiku
@@error variable shows the error number of the last
T-SQL error
@@rowcount variable gives the number of rows affected by
the most recent SQL statements.
| Is This Answer Correct ? | 9 Yes | 7 No |
Post New Answer View All Answers
How to create a view on an existing table in ms sql server?
What is a trigger what are the advantages of trigger?
What is the difference between the 2 operating modes of database mirroring?
What is federation member?
Where are full-text indexes stored?
What are the elements of dbms?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What specific conditions database should meet, before you can bulk copy data into it using bcp?
How to grant a permission in ms sql server using "grant execute" statements?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
Do you think BCNF is better than 2NF & 3NF? Why?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
How to list all user defined functions in the current database?
Name three of the features managed by the surface area configuration tool? : sql server security
Why use “in” clause in sql server?