How do you find the error, how can you know the number of rows affected by last SQL Statement?
How do you find the error, how can you know the number of rows affected by last SQL Statement?
✍: Guest
Answer1
@@errors->give the last error occured in the current DB.
Ans. select @@rowcount
Answer2.
Use @@ERROR which returns the error number for the last Transact-SQL statement executed fro knowing the error.
Use @@ROWCOUNT which returns the number of rows affected by the last statement for finding the no of rows affected.
2014-11-03, 1449👍, 0💬
Related Topics:
What is job?
What is job? It can be defined as a task performed by a computer system. For example, printing a file is a job. Jobs can be performed by a single program or by a collection of programs. 2014-10-31, 1631👍, 0💬