Sysbase存储过程1例

--exec procedure t16 '123'
create procedure t16
@caller varchar(10)=null,
@i int output,
@num varchar(10)=null output,
@fen int output
as
declare
@numg varchar(10) ,
@feng int,
@j int
declare sele_cursor cursor for
select callerid,sum(timelen) from worldcup2006 group by callerid order by sum(timelen) desc

open sele_cursor
fetch sele_cursor into @numg, @feng
select @j=0

while @@sqlstatus=0
begin
select @j=@j+1
if @numg=@caller
begin
select @i=@j, @fen=@feng, @num=@numg
break
end
fetch sele_cursor into @numg, @feng
end
close sele_cursor

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/790981/viewspace-904126/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/790981/viewspace-904126/