我是sql server触发器的新手，曾尝试编写一个不符合我要求的触发器。我肯定有一个明显的原因，但我可以´你没看到问题吗？你们中有谁更擅长这一点，看到任何明显的错误（s）我做了我的触发脚本？当表booking被插入或更新时发生的事情实际上并不是什么，但是我曾经希望当列faretypeid='fakt'时，列faretocollect已经更改为0。

ALTER TRIGGER [dbo].[Fare] 
   ON  [dbo].[Booking] 
   AFTER INSERT,UPDATE
   AS 
BEGIN
SET NOCOUNT ON;

Declare @bo_id int
Declare @leg_id int
Declare @fare_sum real
Declare @Payment_Type_Id varchar

Select @bo_id = inserted.bookingid from inserted
Select @fare_sum = inserted.fareamount from inserted
Select @leg_id = ba.LegId from BookingActivity ba inner join BookingLegs bl on bl.LegId=ba.LegId where bl.BookingId=@bo_id and bl.LegNum=0
Select @Payment_Type_Id = inserted.PaymentTypeId from inserted

IF  @Payment_Type_Id = 'FAKT'
    BEGIN
        UPDATE Booking
        SET FareToCollect = 0
        FROM inserted ins
        INNER JOIN booking bo on ins.BookingId=bo.BookingId 

        UPDATE BookingActivity
        SET FareAmount = 0
        FROM BookingActivity 
        WHERE BookingActivity.LegId=@leg_id
    END;
ELSE
    BEGIN
        UPDATE Booking
        SET FareToCollect = @fare_sum
        FROM inserted ins
        INNER JOIN booking bo on ins.BookingId=bo.BookingId

        UPDATE BookingActivity
        SET FareAmount = @fare_sum
        FROM BookingActivity
        WHERE BookingActivity.LegId=@leg_id 
    END

END