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
The transactions subject is a very important one in SQL Server and a must have knowledge for all the good developers. However, although mostly everybody is familiar with the concept of transactions and is also able to use them successfully in SQL Server, there may be some more sensitive issues regarding transactions which are not Read More