Assigning Record IDs

dkspivey · November 12th, 2004, 11:50 AM

Hello. I am working on an application that will allow users to create new entries for an accounting database. How do I go about having the program assign each entry a record ID after the user clicks the submit button?

Any help is greatly appreciated. Thanks.

--DK Spivey

jaucourt · November 12th, 2004, 12:39 PM

If you're adding records using a stored procedure, the @@IDENTITY variable will give you the last identity added to a table, for example:

Code:

CREATE PROCEDURE JobsInsert 
    (
        @jobDesc varchar(50)
        @min_lvl int
        @max_lvl int
    )
AS
INSERT INTO jobs (job_desc,min_lvl,max_lvl)
VALUES (@jobDesc,@min_lvl,@max_lvl)
SELECT @@IDENTITY AS 'Identity'

GO

If you execute a scalar against this, it will return the new identity