Hi i have a Query Like this:

INSERT INTO TABLE1
SELECT * FROM TABLE2

TABLE1 has a identity column,
now i want to know what identities have been inserted into TABLE1 after the Query executes.



Be Sure,
Hossein

__________________
Be Sure,
-hossrad

One way is to initially store the last identity value in your first table into a local variable and then do the insert. Anything higher than that number are the values inserted to it:

DECLARE @LastIdentity INT
SELECT @LastIdentity = MAX(ID) FROM Table1

INSERT INTO TABLE1
SELECT * FROM TABLE2

SELECT * FROM TABLE1 WHERE ID > @LastIdentity

SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
http://www.sql-server-helper.com/free-test/default.aspx

Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp