Insert Select Stored Procedure

[EscapeUK]

I need a store procedure that first of all inserts a record then returns the ID number which is automatically generated for the inserted record.

Can this be done in the same stored procedure, if yes can you help with the code.

 

[cdukes]

INSERT X,y,Z
INTO tblABC VALUES (1,2,3)

Return (@@Identity)

This assumes that the table has an identity field defined as the primary key.

hope this helps,

Chris Dukes