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
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What is the simplest way to create a new database in ms sql server?
What does dml stand for?
Explain primary key and foreign key constraints?
How to convert numeric expression data types using the cast() function?
Do you know the cursor optimization tips?
What is an indice?
What are difference between Cluster index and Non-Cluster index?
What factors you will consider calculating the storage requirement for that view?
application server is slow what may be the problem
How to create function without parameter in sql server?
Explain system functions or built-in functions? What are different types of system functions?
What are the export options of ssrs?
How do I create a trace in sql server?
What are the High-Availability solutions in SQL Server and differentiate them briefly?