以前很少用觸發器，因為觸發器在資料庫中雖然好用，但是一旦出現邏輯問題可能產生更大得危險，昨天在使用觸發器過程中發現，觸發器得返回錯誤，.net並不一定能全部認識，有時候就沒什麼反映,如下觸發器，復原事務後，.net並沒有什麼反映。
</p><p>CREATE TRIGGER [Insert_ NAME] ON dbo.Plan_Ship<br />FOR INSERT<br />AS<br />DeClare<br />@Plan_NO int,<br />@AttemperNO int,<br />@num1 int,<br />@num2 int<br />set @Plan_NO = (Select Plan_NO from inserted)<br />set @attemperNO = (Select attemperNo from inserted)<br /> set @num1= (Select sum(FullTicket+HalfTicket+Guide) num from Plan_Predict where Plan_No = @Plan_No )------求出所有該團隊人數<br /> set @num2 = (select seat from ship_attemper where attemperNO = @attemperNO)<br />if exists (select * from PlanSumSeat where attemperNO = @attemperNO)</p><p>begin<br /> if @num1<(select sumSeat from PlanSumSeat where attemperNO = @attemperNO)<br /> begin<br /> update PlanSumSeat set sumSeat=(SumSeat-@num1) where attemperNO = @attemperNO<br /> update plan_predict set Ifshiped=1 where Plan_no = @PlanNO --設定該團已經配船<br /> end<br /> else<br /> begin<br /> Raiserror('不成插入一個大於船舶數量得團隊',10,3)<br /> RollBack ----復原整個事務<br /> end<br />end<br />else if @num1 < @num2<br /> begin<br /> insert into PlanSumSeat (attemperNO,sumSeat) values(@attemperNO,(@num2-@num1))<br /> update plan_predict set Ifshiped=1 where Plan_no = @PlanNO --設定該團已經配船<br /> end<br /> else<br /> begin</p><p> Raiserror('不成插入一個大於船舶數量得團隊',10,3)<br /> Rollback ------如果大於船座位就復原整個事務<br /> end</p><p>
