vb如何调用sqlserver中自定义函数 并且得到返回值
数据库自定义函数如下,返回是字符串
在vb中用ado如何调用这个函数呢?
如何得到返回值?
CREATE FUNCTION [dbo].[F_GetTaskInfoByEmpName]
(
-- Add the parameters for the function here
@emp_name varchar(20)
)
RETURNS varchar(1000)
在vb中用ado如何调用这个函数呢?
如何得到返回值?
...全文
请发表友善的回复…
发表回复
fjm_520 2012-10-09
- 打赏
- 举报
[Quote=引用 1 楼 的回复:]
函数参数那里加个output
[/Quote]
我程序里调用:
Private Sub Command4_Click()
Dim db As ADODB.Connection 'ado连接对象
Dim dbcmd As New ADODB.Command 'ado命令对象
Dim dbpara As New ADODB.Parameter 'ado参数对象
Dim rs As New ADODB.Recordset
Set db = cc.Fun_GetConnecttion(2)
Set dbcmd.ActiveConnection = db
'test3
dbcmd.CommandText = "F_GetTaskInfoByEmpName"
dbcmd.CommandType = adCmdStoredProc
Set dbpara = dbcmd.CreateParameter("para1", adVarChar, adParamInput, 20, "adm")
dbcmd.Parameters.Append dbpara
dbcmd.Execute
怎么加参数啊
End Sub
函数参数那里加个output
[/Quote]
我程序里调用:
Private Sub Command4_Click()
Dim db As ADODB.Connection 'ado连接对象
Dim dbcmd As New ADODB.Command 'ado命令对象
Dim dbpara As New ADODB.Parameter 'ado参数对象
Dim rs As New ADODB.Recordset
Set db = cc.Fun_GetConnecttion(2)
Set dbcmd.ActiveConnection = db
'test3
dbcmd.CommandText = "F_GetTaskInfoByEmpName"
dbcmd.CommandType = adCmdStoredProc
Set dbpara = dbcmd.CreateParameter("para1", adVarChar, adParamInput, 20, "adm")
dbcmd.Parameters.Append dbpara
dbcmd.Execute
怎么加参数啊
End Sub
發糞塗牆 2012-10-09
- 打赏
- 举报
函数参数那里加个output