How do you call a MSSQL stored procedure from ASP

How do you call a MSSQL stored procedure from ASP

Call a MSSQL stored procedure from ASP

And here’s the ASP code to call it.

<%

Set cn = Server.CreateObject("ADODB.Connection")

Set cmd = Server.CreateObject("ADODB.Command")

cn.Open "data source name", "userid", "password"

Set cmd.ActiveConnection = cn

cmd.CommandText = "sp_test"

cmd.CommandType = adCmdStoredProc

' Ask the server about the parameters for the stored proc

cmd.Parameters.Refresh

' Assign a value to the 2nd parameter.

' Index of 0 represents first parameter.

cmd.Parameters(1) = 11

cmd.Execute

%>