Trigger - insert into one table update into another table

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.
Trigger - insert into one table update into another table
  • Interview Candidate
  • 4
  • 20100

Showing Answers 1 - 4 of 4 Answers

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.

  Was this answer useful?  Yes

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....

  Was this answer useful?  Yes

Avinash

  • Aug 10th, 2015
 

We can use instead of trigger in this case

  Was this answer useful?  Yes

Nagendra

  • Sep 10th, 2015
 

Code
  1.  

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions