Join tblInterfaceExport
LEFT Join tblInterfaceExport/ Join tblInterfaceExport 第一个为 tblInterfaceExport连接存在的值,第二个为不包括存在的值---结果相反
LEFT Join tblInterfaceExport/ Join tblInterfaceExport 第一个为 tblInterfaceExport连接存在的值,第二个为不包括存在的值---结果相反
deleted表是修改前的数据,inserted是修改后的数据,
SQL内部有个delete和insert的过程.
Insert tblInterfaceExport (ExternalId, EventId)
Select I.InterfaceExportID, I.EventId
From Inserted I left Join tblInterfaceExport IE ON I.ExternalId = IE.ExternalId
where I.IsComplete = 1 and I.SendToInterface = 1 and I.TransferState = 4 and IE.ExternalId is null
是不是应该修改成这样
Insert tblInterfaceExport (ExternalId, EventId)
Select I.InterfaceExportID, I.EventId
From Inserted I left Join tblInterfaceExport IE ON I.InterfaceExportID= IE.ExternalId
where I.IsComplete = 1 and I.SendToInterface = 1 and I.TransferState = 4 and IE.ExternalId is null因为I.InterfaceExportID 对应的是 IE.ExternalId
Insert tblInterfaceExport (ExternalId, EventId)
Select I.InterfaceExportID, I.EventId
From Inserted I left Join tblInterfaceExport IE ON I.InterfaceExportID= IE.ExternalId
where I.IsComplete = 1 and I.SendToInterface = 1 and I.TransferState = 4 and IE.ExternalId is null因为I.InterfaceExportID 对应的是 IE.ExternalId