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 |
|
smr
Starting Member
1 Post |
 Posted - 2004-08-29 : 12:05:23
|
| What are the options when creating a trigger to handle multirow inserts where the standard INTO INTO TableName Select Field1, Field2 from Inserted will not work (ie. the target table has more fields or a identity field as the 1st field). |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-08-30 : 05:03:26
|
| this my help in BOL: "triggers, multirow" in indexGo with the flow & have fun! Else fight the flow :) |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-30 : 08:07:14
|
| What are the options when creating a trigger to handle multirow inserts where the standard INTO INTO TableName Select Field1, Field2 from Inserted will not work (ie. the target table has more fields or a identity field as the 1st field).--??? It will still work in this instance. You are going to have to decide what goes in those other fields though. You would leave out the identity column though. Give us some example CREATE TABLE, CREATE TRIGGER, and INSERT statements and explain the problem you are having. The post doesn't give us enough information to help you except to refer you to Books Online like spirit did.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Trigger, options for Multirow