SQL Rollback Transaction

Question

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,