Post reply

NULL-value-aware Update Trigger

  • March 9, 2007 at 1:41 pm

    #95169

    I cannot get this to work within my TRIGGER .. AFTER UPDATE.....

    SELECT @Count=count(*) FROM SELECT @SomeColumns FROM inserted

           UNION ALL SELECT @SomeColumns FROM deleted

    I  need to determine which columns the Client has modified, so that I can check other 'related' columns.  ( The if update(columnname) will not do because of null-values.)

    It should produce 1 if all of 'SomeColumns' are the same, or 2 if any values (including nulled columns) have been altered.

    This table has 200+ columns, where These5 depend on Those10, if theOther6 are not the same as FewMore.    < is that clear ???

    Any help is appreciated. 

  • March 9, 2007 at 2:38 pm

    #694198

    I think you lost me here.  It will be a big help (to you) to include an example including DDL and sample data and your desired result. 

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Viewing 2 posts - 1 through 2 (of 2 total)

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