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 - 2000-09-16 : 20:40:13
|
D-man writes "What I need should be simple for you SQL gurus, but I can't seem to figure it out. I need a simple update trigger. I've been through MS SQL Server reference and still no light bulb.
Here's what I need: When Table1.ColumnB is changed to 'N', all the records in Table2.ColumnB are updated to 'Y' but only where Table2.ColumnA(a FK of Table1's PK) is equal to the PK in Table1 for the record that was updated.
Any help you can provide, code examples or good URLs to learn more about triggers, is greatly appreciated.
Thanks!"
|
|
|
|
|
|
Trigger hell....please help!