以下以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
運行後, 輸出結果如下:
(所影響的行數為 91 行)
Alfreds Futterkiste
Ana Trujillo Emparedados y helaDOS
Antonio Moreno Taquería
Around the Horn
Berglunds snabbk&oUML;p
Blauer See Delikatessen
Blondesddsl père et fils
Bólido Comidas preparadas
Bon app'
Bottom-Dollar Markets
B's Beverages
Cactus Comidas para llevar
Centro comercial Moctezuma
Chop-suey Chinese
Comércio Mineiro
Consolidated Holdings
DIE Wandernde Kuh
Drachenblut Delikatessen
Du monde entIEr
Eastern Connection
Ernst Handel
Famil