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'