After you do an insert you can return the key for the insert like: INSERT INTO [dbo].[table] ( name , phone) VALUES ("Denny", "555-1234") Return @@IDENTITY Also be sure to read on the differences of SCOPE_IDENTITY() and @@IDENTITY - to be sure which one you should use to return the...