Return Inserted Identity from Stored Procedure
Stored Procedure looks like this:
ALTER PROCEDURE [dbo].[spInsertSomething]
@txtName varchar(255),
@txtDisplayName varchar(80),
@txtPhone varchar(50)
AS
BEGIN
INSERT INTO tblSomeTable
(
txtName ,
txtDisplayName ,
txtPhone
)
VALUES
(
@ txtName ,
@ txtDisplayName ,
@ txtPhone
)
SELECT NEWID = SCOPE_IDENTITY()
END
@txtName varchar(255),
@txtDisplayName varchar(80),
@txtPhone varchar(50)
AS
BEGIN
INSERT INTO tblSomeTable
(
txtName ,
txtDisplayName ,
txtPhone
)
VALUES
(
@ txtName ,
@ txtDisplayName ,
@ txtPhone
)
SELECT NEWID = SCOPE_IDENTITY()
END
asp code:
Set cmd = Server.CreateObject("ADODB.Command")
Set cmd.ActiveConnection = adoCn
cmd.CommandText = "spInsertSomething"
cmd.CommandType = 4
cmd.Parameters(1).Value = txtName
cmd.Parameters(2).Value = txtDisplayName
cmd.Parameters(3).Value = txtPhone
Set insertProgram2Results = cmd.Execute
Response.Write insertProgram2Results("NEWID ")
set PersonID = insertProgram2Results("NEWID ")
Set cmd = Nothing