SQL Server Forums - Select ID After INSERT INTO
>>INSERT INTO table VALUES (value1, value2, value3) SELECT SCOPE_IDENTITY() AS ID What are you trying to do? You didnt give values for value2,value3 If value1 is identity column, then omit it from list and write INSERT INTO table (value2, value3) VALUES ....