Function Procedure(procNam As String) As Recordset If Trim(procNam) = "" Then End Dim svr$ Dim user$ Dim pwd$ Dim db$ Dim conn As New ADODB.Connection Dim arg As Variant Dim procNam_$
Debug.Print procNam_ Set Procedure = conn.Execute(procNam_) End Function我自己打包的一個方法,反回結果為記錄集如下調用:sub call_ dim rs as adodb.recordSet set rs = procedure("procedureName") end sub
If Trim(procNam) = "" Then End
Dim svr$
Dim user$
Dim pwd$
Dim db$
Dim conn As New ADODB.Connection
Dim arg As Variant
Dim procNam_$
svr = "pcxx\sql05"
user = "sa"
pwd = "psw"
db = "OthersPurchaseOrder"
procNam_ = procNam
conn.CursorLocation = adUseClient
conn.Open "driver={SQL Server};" & _
"server=" & svr & _
";uid=sa; " & _
"pwd=" & pwd & _
";database=" & db
Debug.Print procNam_
Set Procedure = conn.Execute(procNam_)
End Function我自己打包的一個方法,反回結果為記錄集如下調用:sub call_
dim rs as adodb.recordSet
set rs = procedure("procedureName")
end sub
将连接方式换成SQL Server的,查询换成存储过程就可以了