ADOStoredProc1执行报错,一个小问题.(在线)

[laihua]

alter ProceDure Getname
@TableName varchar(50)='tablename'

As
select 'columname' = name,
'tblname'=@TableName,
'datype' = type_name(xusertype),
'daleng' = length,
'Prec' = case when
type_name(xtype) = 'uniqueidentifier' then xprec
else OdbcPrec(xtype, length, xprec) end,
'Scale' =OdbcScale(xtype,xscale),
'Param_order' = colid,
'Collation' = collation,
'PK'='Null',
'YNNULL'=case when isnullable =0
then 'NO' else 'YES' end
into #ss from syscolumns
where id = object_id(@TableName)
and number = 0
我在用ADO连上的时候老是报错."commandtext does not return a result set"如果我去掉into #ss这点就可以了,但这要这句请问要怎么办,

[laihua]

怎么这个问题没人答呀.是没人会吗?

[dmqiswei]

简单,你的存储过程参数中是没有返回结果集的参数.在你的存储过程前加上set nocount on
存储过程后加上set nocount off .

[overtime]

将你程序中的ADOStoredProc1.open 更改成ADOStoredProc1.execute试试
open是需要返回结果的