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 - 2007-02-27 : 16:04:52
|
| Jamie writes "i have two tables, tbl_master as my master_file and tbl_tmp as my deleted_file. I need to create trigger so everytime i delete tbl_master from my master_file, automatically my delete trigger will fire and insert a new records to my secondary tables exactly with my master_file.the problem, when i deleted a multi rows, they only 1 one row will created in my tbl_tmp (the last row).Your help is highly appreciated. Thanks" |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-02-27 : 16:17:37
|
| Post your trigger code, some sample data, and expected results. You should always account for multiple rows in your triggers. You should just be able to insert into your secondary table from the deleted pseudo table (i.e. all rows).Mark |
 |
|
|
|
|
|
PROBLEM with Trigger DELETE