在中使用生成的值而不是触发器

在扳机里面你可以得到你想要插入的东西

Select * from INSERTED 

我不确定在哪里可以获得proc创建id所需的@ItemType

create trigger ti_tItem
on tItem
instead of insert
as
begin try
    insert into tItem(ItemID)
    select TempID from [The same code in your procedure]
    where [something] = @ItemType
end try

begin catch
    rollback transaction
end catch

  SELECT * INTO #MyInserted FROM INSERTED 
    SELECT @RowCount = COUNT(*) FROM #MyInserted WHERE ItemID IS NULL

    WHILE @RowCount > 0 
    BEGIN 
       EXEC @TempID = pGeneralIdentifierRetrieve NULL, NULL, @ItemType 
       UPDATE TOP (1) #MyInserted SET ItemID = @TempID WHERE ItemID IS NULL 
       SET @RowCount = 0 
       SELECT @RowCount = COUNT(*) FROM #MyInserted WHERE ItemID IS NULL
    END 

   INSERT INTO tItem (ItemID) SELECT (ItemID) FROM #MySelected