Home Forums SQL Server 2008 SQL Server Newbies Trigger RE: Trigger
vidya_pande
SSCertifiable
Points: 5275
More actions
March 23, 2010 at 4:52 am
#1138083
I wanted to say that you can not have trigger called only once for many insert statements.
I think u could have done this for the below statement-
insert into Table1 (col1, col2) Select col1,col2 from Table2
Here trigger is fired only once.