Post reply

Trigger

  • December 23, 2005 at 1:36 pm

    #92534

    I'm a rokie in sql server and I don't know how make a trigger than fires when update a row, using the updated data.

    Someone can help me, thanks a lot.

     

  • December 23, 2005 at 1:47 pm

    #611365

    The basic shell to an update trigger would be as follows:

    CREATE TRIGGER YourTriggerName ON YourTableName FOR UPDATE

    AS

    Begin

    Your logic here

    End

    Go

    John Rowan

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

  • December 23, 2005 at 1:54 pm

    #611367

    Thanks,

    You can help me with the code; I need to use the updated data for update another table; but I don't know how to write this code.

     

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

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