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 - 2005-02-11 : 07:57:07
|
| Woodley writes "I have an existing table (table A) in SQL 2000 that is updated when users submit an application. I also created a "shell" (table B) of table "A", but it does not contain any data, just column names. When a application is submited to "Table A" I would like create a trigger that would UPDATE that new entry into Table B.Ultimately I would also like to create a trigger that would DELETE each entry in Table B.This way every time a record is placed in "Table B" a email is generated and then the table is emptied so the whole process can start all over again.Any help is greatly appreciated.wlw" |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2005-02-11 : 08:47:07
|
| So, what have you done so far and where are you finding difficulty? Be specific. |
 |
|
|
|
|
|
Create Update Trigger