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; 
arrow
arrow
    文章標籤
    MS-SQL
    全站熱搜

    鴨鴨仔 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄