SQL SERVER - BEGIN TRANSCATION AND ROLLBACK

            SQL SERVER - BEGIN TRANSCATION AND ROLLBACK

 USE [tempdb]
GO
/****** Object:  Table [dbo].[Table_1]    Script Date: 02/06/16 18:05:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table_1](
[fld1] [int] NULL,
[fld2] [int] NULL
) ON [PRIMARY]
GO


Insert into Table_1 (fld1,fld2) Values (0,100)

begin
Select * from Table_1
End 

-- This will Terminat T-sql and rollback same if error occurs
begin Try
begin tran
Delete from Table_1 Where fld1 = 0
Insert into Table_1 (fld1,fld2) Values ('Switin',0)
COMMIT Tran
End Try
begin Catch
SELECT ERROR_MESSAGE() AS ErrorMessage;  
ROLLBACK TRAN 
End Catch



-- Begin End will not stop execution of next T-sql . Its Just logic Grouping of T-SQL
begin
Delete from Table_1 Where fld1 = 0
Insert into Table_1 (fld1,fld2) Values ('Switin',0)
Select * from Table_1
End