Post reply

Execute procedur ethrough trigger

  • January 30, 2009 at 1:34 am

    #94552

    Hi all

    i have a procedure and want to execute through Update trigger

    i want that my procedure execute only when a specefic coulumn in the table is updated

    Thanks in Advance

  • January 30, 2009 at 2:25 am

    #935340

    [font="Verdana"]Then why you need the SProc for this. Just directly write whatever the statements you wants to wtire inside SProc. You can write such statements under IF UPDATE(column_name) condition. It will return TRUE when you will perform Update on such column.

    Mahesh [/font]

    MH-09-AM-8694

  • January 30, 2009 at 2:46 am

    #935348

    Thanks for this

    basicalyu i wri8 stpro fo rmy som erequirments and i have to execute that strpro on table when one specific coumn updated

    a want only the pro executed when that coulumn update dnstead of other tabl eupdated

  • January 30, 2009 at 4:22 am

    #935392

    [font="Verdana"]Yes, It can be done through executing the SProc inside Trigger as well. However I am not aware with the Pros and cons of it.

    If anybody is aware with it, let us know.

    Thanks in advance,

    Mahesh[/font]

    MH-09-AM-8694

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

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