上面是游标 下面是用别的方式代替的游标

declare @info varchar(200)
declare @curs cursor
set @curs=cursor scroll dynamic
for
select '      '+CompanyID+'      '+CompanyCode+'       '+CompanyName from EC_Company
open @curs
fetch next from @curs into @info
while(@@fetch_status=0)
begin
print @info
fetch next from @curs into @info
end




declare @number int 
declare @i int
declare @companyid varchar(36),@companycode varchar(36),@companyname varchar(36)
set @i=1
select @number=count(*) from ec_company 
 
while(@i<=@number)
 begin
    select top(1) @companyid=companyid,@companycode=companycode,@companyname=companyname from EC_Company where companyid not in(select top(@i-1) companyid from EC_Company order by companyid asc)
    print @companyid+'   '+@companycode+'   '+@companyname;
    set @i=@i+1
 end