用sql语句查询如下:
dim conn as string = " Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=test;Data Source=. "
dim rst as adodb.recordset
dim sqlstr as string
sqlstr = " select * from table1 "
set rst = nothing
set rst = new adodb.recordset
rst.CursorLocation =adUseClient
rst.Open sqlstr, conn, adOpenKeyset, adLockReadOnly
假如将sqlstr里的语句写成存储过程m,这个查询该怎么做?
dim conn as string = " Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=test;Data Source=. "
dim rst as adodb.recordset
dim sqlstr as string
sqlstr = " select * from table1 "
set rst = nothing
set rst = new adodb.recordset
rst.CursorLocation =adUseClient
rst.Open sqlstr, conn, adOpenKeyset, adLockReadOnly
假如将sqlstr里的语句写成存储过程m,这个查询该怎么做?
http://blog.csdn.net/online/archive/2004/08/05/66376.aspx
dim m_RS AS adodb.recordset
m_Cmd.ActiveConnection = m_Qcn
m_Cmd.CommandType = adCmdStoredProc
m_Cmd.CommandText = 存储过程m
Set m_RS = m_Cmd.Execute
set rst = new adodb.recordset
dim sqlstr as string
sqlstr = "exec 存储过程名字"
rst.CursorLocation =adUseClient
rst.Open sqlstr, conn, adOpenKeyset, adLockReadOnly
set rst = new adodb.recordset
dim sqlstr as string
sqlstr = "存储过程名字"
rst.CursorLocation =adUseClient
rst.Open sqlstr, conn, adOpenKeyset, adLockReadOnly,adCmdStoredProc