Do you know how many rows will the following statement return, after the query from the thought bubble was executed? SELECT * FROM [dbo].[Numbers] ? In this short article, we will concentrate on the effect a ROLLBACK statement has over the nested transactions in SQL Server.
In this article, I will explain what are nested transactions and how we can use them. The article is structured in the form of interview questions. Some questions may have a more detailed answer than what is needed, but the purpose is to give you a clear overview on this subject, not only a cheat Read More