在vb脚本中调用存储过程-callstoredprocedureinvbscript

0  

I realise this is a bit late, but I found this question when looking for a solution to the same problem. I've solved it like this:

我意识到这有点晚了，但在寻找同一问题的解决方案时我发现了这个问题。我已经解决了这个问题：

Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveCOnnection= ConnVar
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "Test"
cmd.Parameters.Append(cmd.CreateParameter("@my_date", adVarChar, adParamInput,10))
cmd.Parameters("@my_date") = "10/12/2012"

Set rsResults = Server.CreateObject("ADODB.Recordset")
rsResults.CursorLocation = adUseClient
rsResults.Open cmd,,adOpenForwardOnly,adLockBatchOptimistic

Using CursorLocation = adUseClient means you can navigate the rsResults RecordSet using MoveNext, MoveFirst etc.

使用CursorLocation = adUseClient意味着您可以使用MoveNext，MoveFirst等导航rsResults RecordSet。