sql try catch
BEGIN TRY
BEGIN TRAN
--操作语句
COMMIT TRAN;
END TRY
BEGIN CATCH
SET @ErrorMessage = ERROR_MESSAGE()
ROLLBACK TRAN;
END CATCH
BEGIN TRY
BEGIN TRAN
--操作语句
COMMIT TRAN;
END TRY
BEGIN CATCH
SET @ErrorMessage = ERROR_MESSAGE()
ROLLBACK TRAN;
END CATCH