SQL - Structured Query Language |
@@ROWCOUNT Data - VIEW@@Rowcount is returns the number of rows affected by the last statement. If the number of rows is more than 2 billion then use @@ROWCOUNT_BIG option. The following query is used to displays record update status message. --
Example 60 -- USE EBusiness GO SELECT * FROM EMP UPDATE EMP SET Dept_Code = 65 WHERE Emp_Code IS NULL IF @@ROWCOUNT
= 0 PRINT 'Warning: No rows
were updated' GO SELECT * FROM EMP |
* * * * *