Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 insert update one trigger for more table

Author  Topic 

programer
Posting Yak Master

221 Posts

Posted - 2014-01-11 : 07:04:49
Hi,

Is possible to use one trigger for more table which is updated?

Like this:
table1
table2
table3

my code insert in db... if my table table1,table2,table3 updated?
or i need 3 different trigger for this?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2014-01-11 : 12:49:47
you need 3 triggers as a trigger is defined for dml actions happening in one table.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -