How to obtain primary key id of record just inserted 1

[ronspree]

Is there a better way of getting the primary key ID of a record that I had just newly inserted via stored procedure? I currently use:

CREATE PROCEDURE strInsertRecord
@value1 varchar(50),
@value2 varchar(50),
@NewRecordID int OUTPUT
AS
INSERT INTO MyTable (Field1, Field2) VALUES (@value1, @value2)
SET @NewRecordID = [b](SELECT MAX(PrimaryKeyID) FROM MyTable)[/b]
RETURN

 

[jbenson001]

Is "PrimaryKeyID" and identity column? If so return the value of SCOPE_IDENTITY( )

 

[ronspree]

jbenson, thanks for pointing me to the right direction. I'm going to be using @@IDENTITY since I'm using SQL Server 7.0. Thanks again.

 

[jbenson001]

great.. glad to help ...

Jim