Get number of affected rows in sql

By
Advertisement

Introduction:
In my previous article I have explained about  how toDifferent isolation levels in sql server. In  this article I will explain about different how to get the number of rows affected or the use of  @@ROWCOUNT in sql server.

Explanation:
To get the number of rows affected by a query below sql query is used.

@@ROWCOUNT                                

If the number of affected rows is more than 2 billion then use the below query.
ROWCOUNT_BIG

Do you like this article. Then share with your friends. Or like our Facebook page. Or post your comments below…


0 comments:

Post a Comment

Online Casino