Our Training Programs

View all

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

All contents are copyright of their authors.

SQL Rollback Transaction

Home
Forums
SQL

SQL Rollback Transaction

Rocky Royalson

11yAsked Sep 18, 2015, 7:31 AM1kSQL

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,

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Supreeth J11y ago
Accepted answer
Hi,

You can go through

www.indiabix.com

http://www.c-sharpcorner.com/interviews/
Rocky Royalson11y ago
Thank you so much Supreeth for sharing this information :)
Rocky Royalson11y ago
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 Patil11y ago
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.