T-SQL Transaction Template

-- Transaction Template Begin--
BEGIN TRY
 BEGIN TRANSACTION Subs_Import
 BEGIN
  Select 1
 END

 IF (@@ERROR <> 0)
 BEGIN
  ROLLBACK TRANSACTION
 END
 ELSE
 BEGIN
  Commit TRANSACTION
 END
END TRY

BEGIN CATCH
 ROLLBACK TRANSACTION
END CATCH

-- Transaction Template End  --