Ex : T-SQL

Create Table Test (Id int )

BEGIN TRAN

BEGIN TRY
   — execute each statement
   INSERT INTO Test(ID) VALUES (123)
   INSERT INTO Test(ID) VALUES (123)
   INSERT INTO Test(ID) VALUES (123)
   INSERT INTO Test(ID) VALUES (123)   
   INSERT INTO Test(ID) VALUES (123)
   INSERT INTO Test(ID) VALUES (123)
   INSERT INTO Test(ID) VALUES (123)
   INSERT INTO Test(ID) VALUES (123)
   INSERT INTO Test(ID) VALUES (‘ABC’)
 
   — commit the transaction
   COMMIT TRAN
END TRY
BEGIN CATCH
   — rollback the transaction because of error
   ROLLBACK TRAN
   print ‘rollback’
END CATCH

Select * from Test

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: