|
|
|
| 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 Query Output Screen |
* * * * *
|
|
|
|
Copyrights © . Data-e-Education. All Rights Reserved.
Your Comment To AUTHOR