1:没必要用存储过程,直接用 select 就行了. 2:如果一定要用 create procedure test As Select name,sex,address from 表 where sex = '男' 3: dim cn as adodb.connection dim rs as adodb.recordset cn.open ... rs.open " exec test ",cn,... msgbox rs.fields(0)
我只是举个例子而已, to 马可: privat sub form_load() dim cn as new adodb.connection dim rs as new adodb.recordset cn=set new adodb.connection dim connstr as string connstr="provider=microsoft.sqloledb.1;database=cominfo;data source=172.19.3.42;password=;id=;" set rs=new adodb.recordset
create procedure test as select * from name,sex,address from tablename where sex='男' rs.open "exec test",cn,1,3请问代码是这样写的吗?如果是,但是有错误,该怎样修改呢? end sub
2:如果一定要用
create procedure test
As
Select name,sex,address from 表 where sex = '男'
3:
dim cn as adodb.connection
dim rs as adodb.recordset
cn.open ...
rs.open " exec test ",cn,...
msgbox rs.fields(0)
to 马可:
privat sub form_load()
dim cn as new adodb.connection
dim rs as new adodb.recordset
cn=set new adodb.connection
dim connstr as string
connstr="provider=microsoft.sqloledb.1;database=cominfo;data source=172.19.3.42;password=;id=;"
set rs=new adodb.recordset
create procedure test
as
select * from name,sex,address from tablename where sex='男' rs.open "exec test",cn,1,3请问代码是这样写的吗?如果是,但是有错误,该怎样修改呢?
end sub