Cómo se ejecuta un store procedure en ASP

[bakanzipp]

aki te envio un stored con input y output...espero te sirva:

Código:

  
Set cn = server.createobject("ADODB.Connection") 
Set cmd = server.createobject("ADODB.Command") 

cn.ConnectionString = "Tu_DSN"
cn.Open 

With cmd 
Set .ActiveConnection = cn 
    .CommandText = "Tu_Sp" 
    .CommandType = 4 
Set params = .Parameters 
End With 

params.Append cmd.CreateParameter("@input1", adVarChar, adParamInput, 3)
params.Append cmd.CreateParameter("@input2", adVarChar, adParamInput, 4)  
params.Append cmd.CreateParameter("@output", adVarChar, adParamOutput, 255)

params("@input1") = variable_1
params("@input2") = variable_2
			
cmd.Execute   , , adExecuteNoRecords 
			
Respuesta = params("@output")

;)