SQL Server - Return value after INSERT

Question

I'm trying to get a the key-value back after an INSERT-statement. Example: I've got a table with the attributes name and id. id is a generated value.

 INSERT INTO table (name) VALUES('bob');

Now I want to get the id back in the same step. How is this done?

We're using Microsoft SQL Server 2008.

Answer 1

You can use the code given below, instead of using separate SELECT.

Are you interested in learning SQL from the basics! Refer to this video on SQL provided by Intellipaat:

Query:

INSERT INTO table (name)

OUTPUT Inserted.ID

VALUES('bob');

The above code only works for Non-IDENTITY columns.