SQL Server插入身份列表 [英] SQL Server list of insert identities
本文介绍了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 ...
这篇关于SQL Server插入身份列表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文