Home Forums SQL Server 2008 SQL Server 2008 - General Get number of rows updated/Inserted/deleted by boclk of t-sql code RE: Get number of rows updated/Inserted/deleted by boclk of t-sql code

  • May 8, 2012 at 10:28 am

    #1484650

    I think @@ROWCOUNT is what you're after.

    http://technet.microsoft.com/en-us/library/ms187316(v=sql.105).aspx

    As in, SET v_count = @@ROWCOUNT.

    Cheers