@@RowCount vs RowCount_Big(): Functionally there is no difference between these two. Both returns the number of records returned by the last executed SQL statement. But the return value of @@ROWCOUNT is INT whereas the return type of ROWCOUNT_BIG () is BigInt.  

Read More