Home Forums SQL Server 7,2000 T-SQL @@rowcount Returns 0 RE: @@rowcount Returns 0

  • February 6, 2007 at 5:14 pm

    #688172

    IF EXISTS (select 1 from INSERTED)

    will perform faster.

    If your trigger is for delete as well use

    IF EXISTS (select 1 as One from INSERTED UNION select 1 as One from DELETED)

    _____________
    Code for TallyGenerator