以下是我的EXCUTE的使用例子: dim con as connection set con=new connection con.connectionstring="provider=msdasql;driver=sql server;server=myserver;uid=sa;pwd=;database=mydatabase" con.open dim sql as string sql="select * from mytable" con.execute sql上面的SQL是T-SQL语句。
在存储过程中参数值只能返回一个值,当返回结果是数据集时,它们只能返回最后一条记录的值。要得到数据集。要将结果传给recordset. dim rs as recordset set rs=execute
dim con as connection
set con=new connection
con.connectionstring="provider=msdasql;driver=sql server;server=myserver;uid=sa;pwd=;database=mydatabase"
con.open
dim sql as string
sql="select * from mytable"
con.execute sql上面的SQL是T-SQL语句。
dim rs as recordset
set rs=execute