帮忙看下哪里错了

Question

我要修改触发器，哪里错了，求助set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
goALTER TRIGGER [T_ZQ_PurchaseOrder_Detail_TRIGGER_UPDATE]
ON [dbo].[T_ZQ_PurchaseOrder_Detail]
FOR UPDATE
AS
IF UPDATE(HGSL)
BEGIN
UPDATE dbo.T_ZQ_PurchaseOrder_Detail set
HGMY=T_ZQ_PurchaseOrder_Detail.HGSL*TBOOKINFO.FBookPurchaseMoney FROM TBOOKINFO WHERE TBOOKINFO.FBOOKID=T_ZQ_PurchaseOrder_Detail.GYSSPXXID,
HGSY=HGMY*HGZK
END错误提示：消息 102，级别 15，状态 1，过程 T_ZQ_PurchaseOrder_Detail_TRIGGER_UPDATE，第 9 行
',' 附近有语法错误。

Answer 1

ALTER TRIGGER [T_ZQ_PurchaseOrder_Detail_TRIGGER_UPDATE]
ON [dbo].[T_ZQ_PurchaseOrder_Detail]
FOR UPDATE
AS
IF UPDATE(HGSL)
BEGIN
UPDATE dbo.T_ZQ_PurchaseOrder_Detail set
HGMY=T_ZQ_PurchaseOrder_Detail.HGSL*TBOOKINFO.FBookPurchaseMoney FROM TBOOKINFO
WHERE TBOOKINFO.FBOOKID=T_ZQ_PurchaseOrder_Detail.GYSSPXXID
and HGSY=HGMY*HGZK
END

Answer 2

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
goALTER TRIGGER [T_ZQ_PurchaseOrder_Detail_TRIGGER_UPDATE]
ON [dbo].[T_ZQ_PurchaseOrder_Detail]
FOR UPDATE
AS
IF UPDATE(HGSL)
BEGIN
UPDATE dbo.T_ZQ_PurchaseOrder_Detail set
HGMY=T_ZQ_PurchaseOrder_Detail.HGSL*TBOOKINFO.FBookPurchaseMoney FROM TBOOKINFO WHERE TBOOKINFO.FBOOKID=T_ZQ_PurchaseOrder_Detail.GYSSPXXID and HGSY=HGMY*HGZK
END

Answer 3

BEGIN
UPDATE dbo.T_ZQ_PurchaseOrder_Detail 
set HGMY=T_ZQ_PurchaseOrder_Detail.HGSL*TBOOKINFO.FBookPurchaseMoney FROM TBOOKINFO WHERE TBOOKINFO.FBOOKID=T_ZQ_PurchaseOrder_Detail.GYSSPXXID  --","-->不需要
set HGSY=HGMY*HGZK   --加set
END

Answer 4

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
goALTER TRIGGER [T_ZQ_PurchaseOrder_Detail_TRIGGER_UPDATE]
ON [dbo].[T_ZQ_PurchaseOrder_Detail]
FOR UPDATE
AS
IF UPDATE(HGSL)
BEGIN
UPDATE dbo.T_ZQ_PurchaseOrder_Detail set
HGMY=T_ZQ_PurchaseOrder_Detail.HGSL*TBOOKINFO.FBookPurchaseMoney FROM TBOOKINFO WHERE TBOOKINFO.FBOOKID=T_ZQ_PurchaseOrder_Detail.GYSSPXXID,--这里的','用错了改用'and'
HGSY=HGMY*HGZK
END
-----------------------------------------------------------------------