Nested transactions in Sql Server

by

With a nested transaction, a commit does not write any changes to disk, except for the top level transaction. A rollback, however works regardless of the level of the transaction, so yes, it will roll the inner transaction back.

More Related Contents:

  1. SQL Server: Isolation level leaks across pooled connections
  2. Do I really need to use “SET XACT_ABORT ON”?
  3. TSQL Try / Catch within Transaction or vice versa?
  4. What happens if you don’t commit a transaction to a database (say, SQL Server)?
  5. Subquery in select not working in SQL Server
  6. Storing images in SQL Server?
  7. Escape a string in SQL Server so that it is safe to use in LIKE expression
  8. Limitations of SQL Server Express
  9. SQL time difference between two dates result in hh:mm:ss
  10. Storing files in SQL Server
  11. What is the best way to truncate a date in SQL Server?
  12. Dynamic SQL (passing table name as parameter)
  13. Dapper.NET and stored proc with multiple result sets
  14. “order by newid()” – how does it work?
  15. T-SQL Dynamic SQL and Temp Tables
  16. How to determine total number of open/active connections in ms sql server 2005
  17. Tablix: Repeat header rows on each page not working – Report Builder 3.0
  18. ORDER BY DATE showing NULLS first then most recent dates
  19. How can I determine in SQL Server if a dateTime range overlaps another
  20. How to split a string after specific character in SQL Server and update this value to specific column
  21. Avoid Naming User Stored Procedures SP% or SP_%
  22. SQL Server Configuration Manager cannot be found
  23. How to prevent SQL Server LocalDB auto shutdown?
  24. How can I run just the statement my cursor is on in SQL Server Management Studio?
  25. Set database collation in Entity Framework Code-First Initializer
  26. How do you get to limits of 8060 bytes per row and 8000 per (varchar, nvarchar) value?
  27. What does the SQL # symbol mean and how is it used?
  28. How do you deal with blank spaces in column names in SQL Server?
  29. Oracle sequence but then in MS SQL Server
  30. ODBC Call Failed with stored procedure – Pass through query

Leave a Comment