Post reply

After Update Trigger Problem

  • September 7, 2010 at 3:12 am

    #144963

    Hi Frnds,

    I wrote an simple AFTER UPDATE trigger, i just wanted to amke a try to GET THE VALUES FROM THE DELETE (table created virtually during the update process), plz help me

    Create Trigger num on dbo.Number

    After Update

    AS

    Declare @S varchar(50)

    BEGIN

    select @S = (select a from deleted)

    insert into number (a) values (@s)

    END

    *****select * from number ***********

    A B C

    ------------------------

    1 2 3

    4 5 6

    My update statement will be like,

    update number set b = 5 where c = 6

    I guess, trigger is not getting fired, can u tel me wats the problem here ?

  • September 7, 2010 at 3:16 am

    #1217196

    Hi Dear frnds,

    Sry for wastin ur precious time, its working perfectly. As i updated the same value in A coloumn, so i tot, trigger is nt getting called. Sry ;-);-);-);-);-)

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

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