what is the use of @@ROWCOUNT function in SQL server?
by
Narain_Siddharth
on
Jun 01, 2011
Category:
SQL Server
|
Level:
Beginner
|
Views:
88
|
Points:
25
|
Silver ★
|
|
|
The @@ROWCOUNT function in SQL server is used to returns the no of rows affected by the last executed statement. Return type of @@ROWCOUNT is integer. for example, find no of rows affected when updating a rows.
UPDATE employee SET emp_salary = 500000
WHERE emp_grad = '6'
if @@ROWCOUNT > 0
//Do process
|
Like this question? Bookmark and Share:
« Previous Question | Next Question »
|
|
|
|
No Response found!
|
|
|