Home Forums SQL Server 2005 T-SQL (SS2K5) Insert trigger not working when update trigger enabled RE: Insert trigger not working when update trigger enabled

  • March 17, 2009 at 9:24 am

    #961150

    gdavidson (3/17/2009)

    set @CRno = (SELECT IEIncidentID FROM inserted)

    set @EventID = (SELECT IEventID FROM inserted)

    set @EventTitle = (SELECT IETitle FROM inserted)

    set @EventTemplateID = (SELECT IETemplateID FROM inserted)

    What's going to happen when more than one row is inserted/updated in a statement and the inserted table contains multiple rows?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass