How Do You Find The Error, How Can You Know The Number Of Rows Affect

1.	How Do You Find The Error, How Can You Know The Number Of Rows Affected By Last Sql Statement?
Answer» 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. 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.

How Do You Find The Error, How Can You Know The Number Of Rows Affected By Last Sql Statement?

Answer»

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.

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.