初学请教:如何在SELECT中调用存储过程
以前是在ASA中,定义如下:
create Function f_get_custsname(in @custno char(10))
returns char(20)
begin
declare @custsname char(20);
select custsname into @custsname from customer where custno = @custno;
return @custsname;
end
然后在另外的SELECT中就可以用:
select a.doccno , f_get_custsname(a.custno) as custsname from tablename as a where ...
现在转到Sybase11,好象没有办法做到啊? 哪位大哥可以教一下? 谢谢