SQL Server 插入标识列表 [英] SQL Server list of insert identities

问题描述

我有一个带有自动增量 ID 的表，我正在做一个

I have a table with an autoincrement id that I am doing a

INSERT INTO ( ... ) SELECT ... FROM ...

有没有办法让我获得已插入的 id 列表?

Is there a way for me to get the list of id's that have been inserted?

我想我可以在插入之前然后在插入之后获得最大 id 并假设中间的所有内容都是新的，但是如果从其他地方插入一行，我可能会遇到问题.有没有合适的方法来做到这一点?

I was thinking I could get the max id before the insert then after and assuming everything in between is new, but then if a row gets inserted from somewhere else I could run into problems. Is there a proper way to do this?

我使用的是 SQL Server 2005

I am using SQL Server 2005

推荐答案

使用输出子句.

DECLARE @InsertedIDs table(ID int);

INSERT INTO YourTable
    OUTPUT INSERTED.ID
        INTO @InsertedIDs 
    SELECT ...

这篇关于SQL Server 插入标识列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！