Sub Transaction Problem

gaurav_jain2403 · May 13th, 2006, 08:33 AM

Hello Friends,
Can anyone of you tell me the output of following query using Transactions:

BEGIN TRANSACTION
      INSERT TABLE1(COL_1,COL_2)
      VALUES('ONE','TWO')
      BEGIN TRANSACTION
      INSERT TABLE1(COL_1,COL_2)
      VALUE('THREE','FOUR')
      ROLLBACK
COMMIT

How many rows will be inserted,if any? What is the logic?
Thank you.

Gaurav Jain

joefawcett · May 13th, 2006, 08:46 AM

When's this due in by :)?

--

Joe (Microsoft MVP - XML)

gaurav_jain2403 · May 13th, 2006, 08:57 AM

I didn't expect such a reply. Cannot anyone tell me the output of running the above query.

Jeff Mason · May 13th, 2006, 10:53 AM

Quote:

quote:Originally posted by gaurav_jain2403
I didn't expect such a reply.

It's just that your question, and the other one you posted in another topic, look suspiciously like homework problems. Joe, and I as well, are just curious when the assignment is due...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com