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这点就可以了,但这要这句请问要怎么办,
@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这点就可以了,但这要这句请问要怎么办,
存储过程后加上set nocount off .
open是需要返回结果的