THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Teaser » transactions   (RSS)
Sorry, but there are no more tags available to filter with.
  • Summer SQL Teaser #9 ROLLBACK

    This one is not so much a teaser but it will show you what you can do in case you want to insert data in a logging table after a rollback occursWithout running this try to guess what the counts of the three tables will be after the rollbackCREATE TABLE Test (id int)CREATE TABLE #Test (id int)DECLARE @Test table (id int)BEGIN TRAN   ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on July 27, 2007
Privacy Statement