Home Forums SQL Server 7,2000 T-SQL Rollback RE: Rollback

  • January 14, 2008 at 5:59 pm

    #767944

    IF @@ROWCOUNT > 10 -- assume that normal query to affect not more than 10 rows

    ROLLBACK

    ELSE

    COMMIT

    _____________
    Code for TallyGenerator