So, I change to: DECLARE @t TABLE (ID int) INSERT INTO FATest (acol) OUTPUT INSERTED.ID INTO @t VALUES ('a test') SELECT * FROM @t (this query works fine when run in M$ SQL Server Management Studio ...

Get ID of The Last Inserted Record If we perform an INSERT or UPDATE on a table with an AUTO_INCREMENT field, we can get the ID of the last inserted/updated record immediately.