Abhay J

• Jan 18th, 2015

 

You can create the trigger before/after insert on A for each row in which you can write the code to update the table B.

Nupur

• Apr 29th, 2015

 

We can insert into one table and update another table....but what if ? ..this case :insert into table A, update Table b and then again insert into Table A and update table B ...isnt this becoming a round about phenomenon and a cascading trigger ....please, somebody clarify this....

Avinash

• Aug 10th, 2015

 

We can use instead of trigger in this case

Nagendra

• Sep 10th, 2015

 

Code
CREATE  TRIGGER  update_trigger


ON CUSTOMER_info 


FOR UPDATE AS


 


BEGIN


    IF UPDATE (cust_name) OR UPDATE (contact)


    BEGIN


        INSERT INTO update_log (


            cust_no


            ,Cust_name


            ,Contact


            ,Date


            )


        SELECT cust_no


            ,cust_name


            ,contact


            ,GetDate()


        FROM INSERTED


 


        INSERT INTO update_log (


        cust_no


        ,Cust_name


        ,Contact


        ,Date


        )


    SELECT cust_no


        ,cust_name


        ,contact


        ,GetDate()


    FROM DELETED


END