declare cursorInsert insensitive cursor for
select ID,货号,类型,出库单编号 from inserted

for read only

open cursorInsert

Fetch Next From cursorInsert into @ID,@ItemNo,@lx,@ckNo
while(@@Fetch_Status<>-1)
begin
    
        
        IF NOT EXISTS (SELECT * FROM Table_仓库_放量产品出库单_明细 WHERE 类型=@lx AND 货号=@ItemNo AND 出库单编号=@ckNo)
        BEGIN
        Update Table_仓库_放量产品出库单_明细 set 品名=
        (select top 1 品名 From Table_产品档案 where 货号=@ItemNo),
        计量单位=(select top 1 计量单位 From Table_产品档案 where 货号=@ItemNo)
        where ID=@ID
        END
        ELSE
            PRINT '同一个单号下存在相同明细!'
            ROLLBACK TRANSACTION

    Fetch Next From cursorInsert into @ID,@ItemNo,@lx,@ckNo
end

Close cursorInsert
Deallocate cursorInsert