4
Reply

SQL Rollback Transaction

Rocky Royalson

Rocky Royalson

Sep 18 2015 7:31 AM
444
Hello Friends,
 
I have one doubt, can anybody please solve my doubt.
 
I have a stored procedure where in I have used Transaction and Triggered. 
 
There are 2 tables, if we insert record into Table "A" there is triggered on Table "A", which will execute and will insert the same record into Table "B".
 
Before committing the transaction, What if I Rollback the transaction then which record will get deleted either from Table "A" or Table "B" and why?
 
Thanks,
 
 

Answers (4)