Home Forums SQL Server 2008 Working with Oracle After Insert trigger RE: After Insert trigger
Jo Pattyn
SSC-Dedicated
Points: 32070
More actions
January 28, 2013 at 9:50 am
#1581699
You cannot update emp again from an after trigger (could cause looping). Try a before insert trigger.
Ps why are you updating the whole table (status=1) for each row?