Post reply

Stored procedure with trigger inside

  • June 1, 2011 at 11:41 am

    #1332674

    it's solved.

    I copyed the object again and put it in the @var1 and it works...

    Maybe it was something like ' or other think...

    Thank you

  • June 1, 2011 at 11:47 am

    #1332682

    Great, not go back and look at Ninja's comments on this trigger.

    It will NOT work properly if more than one row is affected by Insert.

    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

  • June 1, 2011 at 11:50 am

    #1332686

    GilaMonster (6/1/2011)

    Great, not go back and look at Ninja's comments on this trigger.

    It will NOT work properly if more than one row is affected by Insert.

    And AGAIN. WHY oh WHY do you need to put this code in a SP? Why would you ever need to re-update that code daily?!?! or whatever timeframe?

Viewing 3 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply