我的意思是想在存儲過程中返回一個值,在程序中用一變量接收:
以下是我做的:
--存儲過程內容:
Create Procedure MJ_Select_YPM (@Name nvarchar(50) Output) AS
..................程序部分
dim strName as string
'Comm 是ADODB.Command
Comm.CommandText="MJ_Select_YPM ('" & strName & "')"
comm.execute
為什么這樣做會失敗,請各位老鳥賜招
以下是我做的:
--存儲過程內容:
Create Procedure MJ_Select_YPM (@Name nvarchar(50) Output) AS
..................程序部分
dim strName as string
'Comm 是ADODB.Command
Comm.CommandText="MJ_Select_YPM ('" & strName & "')"
comm.execute
為什么這樣做會失敗,請各位老鳥賜招
Dim ADOCmd As ADODB.Command
Dim ADOPrm As ADODB.Parameter
Set ADOCmd.ActiveConnection = ADOCon
With ADOCmd
.CommandType = adCmdStoredProc
.CommandText = "MJ_Select_YPM"
End With sParmName = "Name"
Set ADOPrm = ADOCmd.CreateParameter(sParmName, adVarChar, adParamOutput)
ADOCmd.Parameters.Append ADOPrm Set ADORs = ADOCmd.Execute Debug.Print "Name: " & ADOCmd.Parameters("Name").Value
楼主注意,存储过程的参数类型是output的才可以返回。