sql t-sql. t-sql training

MSSQL @@ROWCOUNT Tutorial

MSSQL @@ROWCOUNT Tutorial

The @@ROW COUNT variable returns the number of rows read by the last executed statement. If any statement does not return any rows, then value of @@ROWCOUNT variable is set to zero.

MSSQL @@ROWCOUNT VARIABLE SYNTAX

@@ROWCOUNT

Using @@ implies that it is a global variable. Also @@ROWCOUNT returns the value of int type i.e. the maximum no of rows @@ ROWCOUNT can return is 231 (2,147,483,647). For returning rows greater than this limit, ROWCOUNT_BIG function is used.

More Information visit: www.sqlschool.com