The system function @@ROWCOUNT is used to return the number of rows that were impacted by the last statement that was executed.
The number of affected rows will be counted and put in the @@ROWCOUNT variable if the DML operation is successful. There are numerous uses for this.
- The @@ROWCOUNT can be used as the endpoint for the loop expression
- If necessary, the application should return the number of rows impacted by the user transaction.
- The entire number of rows in a table can be stored in this temporary variable.
- During the IF ELSE condition.
Example-1: In case of providing the information about the transaction
INSERT INTO Dept (DeptNo, DName) VALUES (60, ‘IT’)
IF @@ROWCOUNT > 0
PRINT ‘Department Information has been stored’
ELSE PRINT ‘Not Inserted’
(1 row affected)
Department Information has been stored
Example-2: In case of breaking in the transaction process.
IF @@ROWCOUNT < 1
SELECT @vcErrorMsg = ”No tickets have been assigned # ” + ””+ CONVERT(VARCHAR(10), @UserID)
Hope you find this article helpful.