BEGIN Try
BEGIN Transaction
......
COMMIT Transaction
END TRY
BEGIN CATCH
ROLLBACK Transaction
......
END CATCH
BEGIN Try
BEGIN Transaction
......
COMMIT Transaction
END TRY
BEGIN CATCH
ROLLBACK Transaction
......
END CATCH