Answer Detail: RE: Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.

GeekInterview.com > Interview Questions > Database > SQL Server

Print |

Question: Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.

January 01, 2008 00:09:33	#10
chauhan_anilit	Member Since: October 2007 Total Comments: 8
RE: Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.
Usha G, your code is right but it only for first (SampleMainTable) table and execute whn you insert a record in the SampleMainTable tabe so its only for SampleMainTable table

Back To Question