SQL INSERT INTO returning autoincrement field.

Question

I'm a long time desktop app C++ programmer new to SQL. I need to insert into a table with an autoincrment field, and have that sql statement return the new value for the autoincrement field.

Something LIKE:

INSERT INTO Entrys ('Name','Description')
VALUES ('abc','xyz')
SELECT Entrys.EntryID WHERE EntryID=[THE ONE JUST INSERTED!]

Sorry for being a noob.

Answer 1

select scope_identity

insert into table values ('string value');select scope_identity()

Details here

Answer 2

See my response to a similar question for PostgreSQL.

Answer 3

Assuming that you're using SQL Server, you can use scope_identity to return "the last identity value inserted into an identity column in the same scope. A scope is a module: a stored procedure, trigger, function, or batch. Therefore, two statements are in the same scope if they are in the same stored procedure, function, or batch."

INSERT INTO Entrys ('Name','Description') VALUES ('abc','xyz');
SELECT SCOPE_IDENTITY() 

Answer 4

In MySQL you can use LAST_INSERT_ID()

Answer 5

In SQL Server, you can also use the OUTPUT clause on your INSERT statement:

INSERT INTO Entrys('Name', 'Description') 
OUTPUT Inserted.EntryID
VALUES ('abc','xyz') 

This will output the newly created IDENTITY field value.