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

Supreeth J · Answer

Hi You can go through www. indiabix .com http://www.c-sharpcorner.com/interviews/

Rocky Royalson · Answer

Thank you so much Supreeth for sharing this information :)

Rocky Royalson · Answer

Thanks Shashank could you please help me with Basic Oop's and Sql interview Questions and Answers blogs and websites I need your help. Actually some real time questions which asked by the interviewer those questions and answers I need to prepare for an interview. Thank you very much!!!!!!

Shashank Patil · Answer

what ever operations done in the transaction will be done in that scope will be rollback by stored procedure as well as trigger Both the record will be deleted from table A as well as B. It keeps all the modifications done by the transaction in its log file. -------------------------------- If it helps Please accept my answer.