SQL Server Transaction By Microsoft

  IF( @@TRANCOUNT = 0 )

    BEGIN

    BEGIN TRANSACTION

    SET @TranStarted = 1

    END

COMMIT TRANSACTION

ROLLBACK TRANSACTION

end