SQL Server 插入标识列表

2022-01-01 00:00:00 sql-server-2005 insert sql-server

我有一个带有自动增量 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 ...

相关文章