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

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

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

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

Select @@Rowcount;

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response