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 |
|
ruan4u
Posting Yak Master
132 Posts |
 Posted - 2004-06-15 : 07:12:35
|
| I am trying to insert into table B in the insert trigger of table A.Do i need to have transactions. All i do is insert into table B. Also when should i have transactions, when i have more than one insert/update |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-15 : 07:17:40
|
| When you have more then one transaction and you want to maintain consistency across the transactions. Otherwise, SQL Server assumes each transaction is it's own transaction and treats them as such.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
ruan4u
Posting Yak Master
132 Posts |
Posted - 2004-06-15 : 07:21:38
|
| How do i copy a text data from table a to B in a trigger.it doesnt allow. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-06-15 : 08:16:33
|
| You'll have to use an INSTEAD OF trigger for that, as far as I knowKristen |
|
|
|
|
|
|
Transactions Trigger