Interested to Buy Any Domain ? << Click Here >> for more details...
How can you get @@error and @@rowcount at the same time?
- 9 Answers
- 24229 Views
- I also Faced
- E-Mail Answers
Answer Posted / yjreddy
select @@ROWCOUNT
it will give the no of rows affected by last sql statement
select @@ERROR
it will display the error number for last sql statement
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How to use subqueries in the from clause in ms sql server?
What is normalization and its types?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
How to provide default values to function parameters?
What you can do to delete a table without the delete trigger firing?
Explain the working of sql privileges?
Does sql server use t sql?
What happens if null values are involved in string operations?
Is there any difference between the primary key and unique key?
What is 2nf in normalization?
How to create a simple table to test triggers in ms sql server?
How to execute a sql statement using odbc_exec()?
Write a SQL queries on Self Join and Inner Join.
Can you always create a cache of a report?
do you know how to configure db2 side of the application? : Sql server database administration
