Output Parameter in SQL Server:
Code:
insert.asp
Highlight
<% dim conn, cmd set conn = ConnectSQLNT(Application("SearchCom_SqlDatabase"), Application("SearchCom_SqlServer")) set cmd = Server.CreateObject("ADODB.Command") set cmd.ActiveConnection = conn cmd.CommandType = adCmdStoredProc cmd.CommandText = "sp_Insert" cmd.Parameters.Append(cmd.CreateParameter("@Whatever", adVarChar, adParamInput, 255, trim(Request.form("Whatever")))) cmd.Parameters.Append(cmd.CreateParameter("@ID", adInteger, adParamOutput)) cmd.execute ID = cmd.Parameters("@ID").value set cmd = nothing conn.close set conn = nothing %>
sp_Insert
Highlight
CREATE PROCEDURE dbo.sp_Insert @Whatever varchar (255), @ID int OUTPUT AS SET NOCOUNT ON INSERT INTO Survey (Whatever) VALUES (@Whatever) SET @ID = @@IDENTITY GO