存储过程
proc sp_aaa
as
select A,B,C
into
#123
from ABCselect A,B
into
#12
from #123select A from #12在查询分析器中
exec sp_aaa
可显示正确结果字段A但为何在VB中用
adoT
conn.Open connstr
rs.Open "sp_aaa", conn, adOpenKeyset, adLockPessimistic
Set DataGrid1.DataSource = rs
却无法显示也不出现错误提示?
proc sp_aaa
as
select A,B,C
into
#123
from ABCselect A,B
into
#12
from #123select A from #12在查询分析器中
exec sp_aaa
可显示正确结果字段A但为何在VB中用
adoT
conn.Open connstr
rs.Open "sp_aaa", conn, adOpenKeyset, adLockPessimistic
Set DataGrid1.DataSource = rs
却无法显示也不出现错误提示?
否则为何显示不出来?
不要临时表直接用
select a,b,c from abc
则可显示正确结果
一用临时表就出错
有谁知道是什么问题?
as
SET NOCOUNT ON --加上这个试试看
select A,B,C
into
#123
from ABCselect A,B
into
#12
from #123select A from #12SET NOCOUNT OFF --加上这个试试看
试试看呢。。