BEGIN TRANSACTION
INSERT INTO DemoTable VALUES(5,'XYZ','DEMO');
BEGIN TRANSACTION
UPDATE DemoTable SET Col3 = 'Test' WHERE TestID = 5;
COMMIT TRANSACTION;
ROLLBACK;

What is the result of the above code execution?

 Posted by Bandi on 9/27/2013 | Category: Sql Server Interview questions | Views: 3385 | Points: 40
Select from following answers:
  1. The data is rolled back to the transaction starting on line1.
  2. The inserted row does not exist in the table
  3. All of the above.
  4. Only 2
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response