Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Where was the output from a SELECT go in a trigger? RE: Where was the output from a SELECT go in a trigger?

  • May 2, 2016 at 2:16 pm

    #1876039

    Rod at work (5/2/2016)

    However in my testing I noticed that if I set it to what it already is, the UPDATE() function says I've modified it.

    The UPDATE function has nothing to do with whether a value has changed or not. It returns TRUE if the column was included in the UPDATE statement, FALSE if it wasn't.

    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