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 - 2001-05-30 : 23:55:00
|
lalitha writes "I have 2 questions to ask you about triggers.
1) I am trying to insert updated rows in TableA to TableB.
I used Trigger[for UPDATE]. Eventhough the update statement affects more than 1 row...it writes only 1 row to the destination TableB.How can achieve to get all affected rows in the TableB.
2)I am using BCP to insert rows in the table(Say TableA).I have created an INSERT trigger on that TableA.So whenever insert new rows in TableA using BCP I want to copy the newly inserted rows to another table(Say TableB). If I insert rows through Query Analyser using Insert Command into TableA, the trigger gets fired and everything is ok.But with BCP command the trigger is not firing.
Can u please help me to solve the problem?" |
|
|
|
|
|
SQL server (Trigger)