SQl遍历循环方式另游标方式

以下以SQL Server 2000中的NorthWind数据库中的Customers表为例,用 临时表 + While循环 的方法, 对Customers表中的CompanyName列进行遍历

 create table #temp
(
  id int identity(1,1),
  customer nvarchar(50)
)

declare @customer nvarchar(50)
declare @n        int
declare @rows     int

select @n="1

insert #temp(customer) select distinct companyname from customers

select @rows = @@rowcount

 while @n <= @rows
begin
select @customer = companyname
from customers
     where companyname="(select" customer from #temp where id = @n)
order by companyname desc

print(@customer)

select @n = @n + 1

end