该片段可用于存储过程
BEGIN TRY
BEGIN TRANSACTION
......
COMMIT TRANSACTION
SELECT '0'
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION
SELECT '-1'
END CATCH
该片段可用于存储过程
BEGIN TRY
BEGIN TRANSACTION
......
COMMIT TRANSACTION
SELECT '0'
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION
SELECT '-1'
END CATCH