Home Forums SQL Server 2005 T-SQL (SS2K5) update trigger RE: update trigger

  • January 29, 2009 at 8:12 am

    #934713

    GilaMonster (1/29/2009)

    ...So then the trigger would just looks like this

    WHERE i,city != d,city -- don't catch cases where the city has been updated to the same value

    AND d.city LIKE 'p% or d.city LIKE 's%'

    ...

    Just nab the WHERE clause dude.

    Max