mysql 存储过程 try catch_sqlserver 存储过程 try catch TRANSACTION (转)

CREATE PROCEDURE YourProcedure AS BEGIN SET NOCOUNT ON; BEGIN TRY---------------------开始捕捉异常 BEIN TRAN------------------开始事务 UPDATE A SET A.names = B.names FROM 表1 AS A INNER JOIN 表2 AS B ON A.id = B.id UPDATE A SET A.names = B

CREATE PROCEDURE YourProcedure

AS

BEGIN

SET NOCOUNT ON;

BEGIN TRY---------------------开始捕捉异常

BEIN TRAN------------------开始事务

UPDATE A SET A.names = B.names FROM 表1 AS A INNER JOIN 表2 AS B ON A.id = B.id

UPDATE A SET A.names = B.names FROM 表1 AS A INNER JOIN 表2 AS B ON A.TEST = B.TEST

COMMIT TRAN -------提交事务

END TRY-----------结束捕捉异常

BEGIN CATCH------------有异常被捕获

IF @@TRANCOUNT > 0---------------判断有没有事务

BEGIN

ROLLBACK TRAN----------回滚事务

END

EXEC YourLogErrorProcedure-----------执行存储过程将错误信息记录在表当中

END CATCH--------结束异常处理

END

---------------------------------------------记录操作错信息的存储过程--------------------------------------------

CREATE PROCEDURE YourLogErrorProcedure

@ErrorLogID [int] = 0 OUTPUT -- contains the ErrorLogID of the row inserted

AS -- by uspLogError in the ErrorLog table

BEGIN

SET NOCOUNT ON;

-- Output parameter value