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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-25 : 08:34:30
|
amit writes "I have a trigger that watches updates on a table (say, dbo.users) , and inserts a record into a LOG table (say, dbo.users_log) on every update, with a referanct to the ID of the original row updated(dbo.users.ID), that I SELECT from the INSERTED table.
Stuff works great when i update one row at a time, but when i update several rows togethr the INSERTED table has more than one row, hance i cant just SELECT the ID.
Is ther a simple solution, or do i need to code a loop and get nasty?
Thanks
Amit" |
|
|
|
|
|
INSERT multiple rows after UPDATE trigger