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 15:02:00	#9
chihoo2003	Member Since: January 2008 Total Comments: 4
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.
No we cannot generate trigger for two tables. If we want to fire the trigger for two table we can use nested trigger. A trigger invoking another trigger is called as nested trigger.

Back To Question