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

Posted by vishalneeraj-24503 on 1/28/2014 | Category: Sql Server Interview questions | Views: 3162 | 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

Bookmark It

< Previous : What is the return type of @@Rowcount function?

Next > : What is the use of StreamWriter in C#?

More Interview Questions by vishalneeraj-24503

Latest Interview Questions