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 |
|
fredramsey
Starting Member
1 Post |
 Posted - 2010-09-07 : 08:50:07
|
I have two tables. When a record (or records) are added to the first table, I want to add records to the second table, as well as keep up with updates and deletes.I only need the trigger on the first table. When adding a record to the second table, I want to use some values from the first table, as well as some default values. I also need to handle multiple INSERTS, UPDATES, and DELETES when they come through on the same statement.Can someone whip up a quick shell to show me how this would be done? I'd be really grateful. |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-09-07 : 09:06:16
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=170215 perhaps? |
 |
|
|
|
|
|
Trigger Example Needed