--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博客 ” ,链接:http://blog.itpub.net/790981/viewspace-904126/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/790981/viewspace-904126/