C# 调用Sybase的sp_helptext如何取得返回的值？？
如题目
sp_helptext定义如下
注意最后一行！！！！！
create procedure dbo.sp_helptext(in @objname char(128) default
null)
result(text char(80))
begin
declare txt long varchar;
declare currline char(80);
declare i smallint;
declare len integer;
declare posn integer;
declare objid integer;
declare local temporary table tmp__sp_helptext(
ln smallint not null,
text char(80) null,
primary key(ln),
)
in SYSTEM on commit preserve rows;set objid=object_id(@objname);
if objid is null then
return
end if;
if objid >= 100000 and objid < 200000 then
select view_def into txt
from SYS.SYSTABLE where
table_id = objid-100000
else
if objid >= 200000 and objid < 300000 then
select proc_defn into txt
from SYS.SYSPROCEDURE where
proc_id = objid-200000
else
select trigger_defn into txt
from SYS.SYSTRIGGER where
trigger_id = objid-300000
end if
end if;
set i=1;
set len=length(txt);
while(len > 0) loop
set posn=locate(txt,'\x0A');
if(posn > 80 or posn = 0) then
set posn=80;
set currline=substr(txt,1,posn)
else
set currline=substr(txt,1,posn-1)
end if;
insert into tmp__sp_helptext values(i,currline);
set txt=substr(txt,posn+1);
set len=len-posn;
set i=i+1
end loop;
select text from tmp__sp_helptext order by ln asc
end
问题点数：20、回复次数：2Top
1 楼JeasonZhao（沈胜衣）回复于 2006-03-11 18:20:03 得分 0
已经解决，直接使用Command类型为TEXT就可以了，来人接分Top
2 楼sdenli（Fender）回复于 2006-03-11 18:26:46 得分 20
那我就不客气了 接!!!Top
