Query to find no of affected rows in SQL

By
Advertisement
Introduction:
In this article i am going to explain about the query to get number of affected rows by a query in sql server.


Explanation:
To get the number of affected rows in sql server @@ROWCOUNT is used.
Below is the sample query:

UPDATE Employee SET empname= 'kanna'
select @@ROWCOUNT

Do you like this article. Then comment here or share with your friends. Or like our Facebook page. 

0 comments:

Post a Comment

Online Casino