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 |
|
saglamtimur
Yak Posting Veteran
91 Posts |
 Posted - 2002-10-19 : 13:57:28
|
| I have 2 tabels, I want to insert five values to table1 and want to insert 3 of those values into table2. I do with 2 inserts, but want to know if its possible with an after trigger. I dont know how to pass those 3 values to a trigger. if someone drop some example codes i will be pleased.thanks in advanced |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-19 : 14:39:13
|
| You can't pass values to a trigger that were not part of the INSERT or UPDATE operation. It's actually easier to do the operation as 2 INSERT operations anyway, just include the proper parameters for each table. |
 |
|
|
|
|
|
Passing values to a trigger