What is the use of @@Rowcount in Sql Server?

 Posted by vishalneeraj-24503 on 1/28/2014 | Category: Sql Server Interview questions | Views: 1140 | Points: 40
Answer:

@@Rowcount is an in-built Sql Server function which returns number of rows affected by last executed statement.

Example:
Insert into table1(id,name) values(1,'abc');

Select @@Rowcount;


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response