Question

sql server 存储过程返回结果集存入临时表

Answer 1

1
用ado,连接字符串参考下面代码.
dim
sa
as
string
'ip方式
sa
=
"provider=sqloledb;
data
source=
dbserver
,1433;
network
library=dbmssocn;
;initial
catalog=
dbdatabasename
;user
id=
dbusername
;password=
dbpassword"
‘计算机名方式
sa
=
"provider=sqloledb;data
source=dbservername;initial
catalog=dbdatabasename
;user
id=
dbusername
;password=
dbpassword“
2
打开联接后不要用command,用cn
rs=cn.execute(”test()“)
’有参数的例子
rs=cn.execute(”test（1,22,’abc‘）“)