How can you get @@error and @@rowcount at the same time?
- 9 Answers
- 21767 Views
- I also Faced
- E-Mail Answers
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
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
Write the SQL query to drop, truncate and delete table.
What happens on checkpoint?
What is the benefit of normalization?
What is delete query?
What is change data capture (cdc) feature?
Can primary key be null?
How to get the definition of a stored procedure back?
What are a database and a data warehouse?
What is a scheduled job or what is a scheduled task?
What is system stored procedures?
Can you use order by when defining a view?
How is sql server used?
what is a check constraint?
What is history table in sql server?
