BEGIN TRY
BEGIN TRANSACTION;
SQL 內容
多筆INSERT UPDATE DELETE
COMMIT TRANSACTION;
END TRY
BEGIN CATCH
SELECT ERROR_NUMBER() AS ErrorNumber, ERROR_MESSAGE() AS ErrorMessage;
IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION;
END CATCH;
文章標籤
全站熱搜
2017 Fearless (1)