Post reply

Quick question on using a trigger for something....

  • March 6, 2011 at 7:45 am

    #236059

    Ok, I need to perform a sanity check....

    If someone wants to put a trigger on a single field in a highly updated table...

    They must institute the trigger on the entire table, then use a case statement to check the condition of their field.

    Is this correct? Or does SQL 2005 allow you to place an update trigger the change of a particular field?

    Thanks.

  • March 6, 2011 at 10:05 am

    #1295115

    The trigger would have to fire for every update on the table

    It would contain an IF UPDATE(column1) BEGIN END. It's pretty lightweight so you wouldnt even notice it existed unless it fired regularly hit the embedded code.

  • March 7, 2011 at 6:31 am

    #1295294

    Your statement is correct cloud9.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

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

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