adspace


  1. Categories >> Software >> Databases >> DB Architecture
  2. Suggest New Category

Can we use commit inside the trigger? If not then how can we save the transaction made by the trigger?

Question Posted / Chandan Kumar Paswan

Answer Posted / Chandan Kumar Paswan

No, you cannot use COMMIT or ROLLBACK within a trigger. To save the transaction made by a trigger, you must include the trigger in a single transaction with other statements that need to be committed together. In SQL Server, you can use the SAVE TRANSACTION command inside a trigger and then commit the transaction from another stored procedure.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1610