sql 触发器在A表将字段code触发到B表 程序使用时A表和B表的code不一致

Question

USE [UFDATA_009_2019]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[DispatchListByIdTriger]
ON [dbo].[DispatchList] --A表
for insert,update
AS
IF EXISTS (SELECT 1 FROM INSERTED where [bReturnFlag] = 1) AND NOT EXISTS (SELECT 1 FROM DELETED) -- 插入
BEGIN
insert into dbo.DispatchListId --B表
([cDLCode])
select
cDLCode
from INSERTED;
END