Click here to Skip to main content
15,921,716 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i have 3 tables
A,B,C
and i have written stored procedure with join condition and inserted values to table D.
Now what i want is i want to write a TRIGGER such that any update made on A,B,C should update in table D.
how do i do this??
please help me
Posted
Comments
Then go ahead and write TRIGGER. If any problem, come back and ask a question.
[no name] 4-Oct-13 0:09am    
how do i write trigger for one table? any update made on that table should update in 4th table. i have 4 columns in 1st table. so any update made on these 4 columns should update in 4th table. please help how to write?

1 solution

If I understand your question - and take it literally - your problems can be solved easily enough:

You need to put trigger on each table - not one trigger for all three.

More details: SQL TRIGGER from MS^

 
Share this answer
 
Comments
thatraja 3-Oct-13 8:49am    
Yep, 5!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900