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.
| Author |
Topic |
|
bubix
Starting Member
24 Posts |
 Posted - 2005-11-18 : 11:14:20
|
| Hello,I have this case:create trigger trig1 on tableAinstead of updateas begin ... update tableA ... endCan we have an update in a trigger on the same table like this case.P.S: Perhaps my way is not correct but i would like know if i can do that. |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-18 : 11:53:32
|
| Yes, an UPDATE on the table that the Trigger is "ON" is permitted - it will not cause recursion!Kristen |
 |
|
|
|
|
|
Instead of update