Lot of newbies struggle to unserstand how @@Rowcount works in SQL Server. @@Rowcount is used to know the number of rows affected for the last select,insert,update or delete statements. You should use @@rowcount immediately after the statement For example Read More......(<a href="http://sqlserver-qa.net/blogs/extblog/archive/2010/08/08/proper-usage-of-rowcount.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9443" width="1" height="1">