您不能使用传统
INSERT输出非插入字段。请改用合并(注意:仅在数据库兼容性> = 100时有效):
MERGE #tempproduct AS tUSING( SELECt Name , ID FROM product) AS sON (1=0) WHEN NOT MATCHED THEN INSERT (Name) VALUES (Name)OUTPUT inserted.ID, s.ID INTO @OutputAttributesValues;SELECt * FROM @OutputAttributesValues



