T_IM_MaterialReqBill表中原來有一些記錄存在，在下面的觸發器執行時，原有的一些記錄也一起更新了，如何實作原有的記錄不更新，只更新新插入的記錄行？
CREATE TRIGGER[dbo].[T_IM_MaterialReqBill-DDS] ON [dbo].[T_IM_MaterialReqBill]
FOR INSERT,UPDATE
AS
BEGIN
UPDATE t1 SET T1.CFSCDDS=t2.FQTY
FROM T_IM_MaterialReqBill t1
INNER JOIN T_MM_ManufactureOrder t2 ON t2.FID = t1.FSourceBILLID
WHERE t1.FSourceBillTypeID='B2aZSVXaSx6qxdfekgCmrEY+1VI='
END
uj5u.com熱心網友回復：
你得關聯Inserted
CREATE TRIGGER[dbo].[T_IM_MaterialReqBill-DDS] ON [dbo].[T_IM_MaterialReqBill]
FOR INSERT,UPDATE
AS
BEGIN
UPDATE t1 SET T1.CFSCDDS=t2.FQTY
FROM INSERTED t1
INNER JOIN T_MM_ManufactureOrder t2 ON t2.FID = t1.FSourceBILLID
END
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/14554.html
標籤：基礎類
下一篇：請教SQL查詢(MSSQL)