[dba-SQLServer] SQL Server 2005 - Getting back the records affected

jwcolby jwcolby at colbyconsulting.com
Wed Aug 5 22:27:55 CDT 2009


I needed @@RowCount, which of course I found in the OhNoSecond after posting the message.

John W. Colby
www.ColbyConsulting.com


Stuart McLachlan wrote:
> If you are using a query in Management Studio, it will tell you.  If you are using a stored 
> procedure include the line "SET NOCOUNT OFF"
> 



More information about the dba-SQLServer mailing list