--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@]
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博客 ” ，链接：https://blog.itpub.net/790981/viewspace-904126/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
JDom新建和读取xml
下一篇：
tomcat 5.5版本的配置jdbc
请登录后发表评论
登录
全部评论
