BEGIN TRY BEGIN TRAN IF(@HandleType=1) BEGIN UPDATE table SET ... END ELSE BEGIN UPDATE table SET ... UPDATE table SET ... END COMMIT TRAN END TRY BEGIN CATCH ROLLBACK TRAN RAISERROR(N'更新失败',16,1) END CATCH
BEGIN TRY BEGIN TRAN IF(@HandleType=1) BEGIN UPDATE table SET ... END ELSE BEGIN UPDATE table SET ... UPDATE table SET ... END COMMIT TRAN END TRY BEGIN CATCH ROLLBACK TRAN RAISERROR(N'更新失败',16,1) END CATCH