7 Comments on “BEGIN TRAN INSERT INTO table (‘Food’) BEGIN TRAN INSERT INTO table (‘Beverages’) COMMI”

1. Habesha Konjo says:

   November 17, 2011 at 9:23 am

   http://msdn.microsoft.com/en-us/library/ms181299.aspx

   Check out the link above. On the remarks section it says A transaction cannot be rolled back after a COMMIT TRANSACTION statement is executed.

   I don’t understand why the answer for the above question is none.

   
   
   
   0

   
   
   
   0
2. mr_tienvu says:

   November 17, 2011 at 1:09 pm

   Ref: http://msdn.microsoft.com/en-us/library/ms190295.aspx

   “You cannot roll back a transaction after a COMMIT TRANSACTION statement is issued because the data modifications have been made a permanent part of the database.”

   The correct answer is D. Food And Beverages

   
   
   
   0

   
   
   
   0
3. magy says:

   July 17, 2012 at 11:14 am

   This are nested transactions. The answer should be A. None

   CREATE TABLE #AA(Name nvarchar(40))
   BEGIN TRAN
   INSERT INTO #AA VALUES (‘Food’)
   BEGIN TRAN
   INSERT INTO #AA VALUES (‘Beverages’)
   COMMIT TRAN
   ROLLBACK TRAN
   select * from #AA

   
   
   
   0

   
   
   
   0
   1. bhavdip says:

      June 16, 2014 at 3:49 pm

      i am totally agreed with magy

      
      
      
      0

      
      
      
      0
4. Aasdasd says:

   October 16, 2012 at 11:30 am

   please update answer to A

   
   
   
   0

   
   
   
   0
   1. networkmanagers says:

      October 16, 2012 at 3:53 pm

      waiting some comments about this for change .

      
      
      
      0

      
      
      
      0
      1. Ani says:

         January 1, 2013 at 9:04 am

         Answer: A (None)
         Explanation: 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.

         
         
         
         0

         
         
         
         0