can we generate a trigger for two tables?
Database
2
Posts
2
Posters
0
Views
1
Watching
-
can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employye table and department table with employee having department no. laxman
laxman.m wrote:
can we generate a trigger for two tables?
No. (So far in my knowledge.) However, one trigger can be defined for more than one event(that is INSERT, UPDATE, DELETE) and similarly, for each event there can be multiple triggers. For details you can consult with the help documentation (Transact-SQL Help) of Query Analyzer tool. Regards. _____________________________ Success is not something to wait for, its something to work for.