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
转载请注明原文地址: https://ju.6miu.com/read-970233.html
