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 - 2004-09-20 : 08:30:40
|
| vishal writes "I have a table called input and I have a query to carry out multiple inserts into this table(basically an insert copied various times with different values). I want that as soon as one row is inserted into "input" a trigger is fired which copies all values from this table(and some from other tables as well)to another table called mastertable, then the next insert and again trigger should fire and so on...As one row gets copied to mastertable I want some other rules to fire on that row.How do I go about it?? Will be obliged if you can help!" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-20 : 14:23:09
|
| Have you looked up CREATE TRIGGER in SQL Server Books Online?Tara |
 |
|
|
|
|
|
firing trigger upon multiple inserts