devxlogo

Return ID in Same Query as Insert

Return ID in Same Query as Insert

Question:
How do I write a query that does an insert and returns the newly assigned ID from that field, all at one time?

Answer:
The @@IDENTITY variable returns the identity value for the last inserted record. You can insert a record and it selects the @@IDENTITY value, like this:

INSERT INTO jobs (job_desc,min_lvl,max_lvl)VALUES ('Accountant',12,125)SELECT @@IDENTITY AS 'Identity'

devx-admin

Share the Post: