SQL查询遍历数据方法二 [ 游标 + While循环]

以下以SQL Server 2000中的NorthWind数据库中的Customers表为例,

用  游标(Cursor) + While循环 的方法, 对Customers表中的CompanyName列进行遍历

declare @customer nvarchar(50)

declare pcurr cursor forselect distinct companyname from customers

open pcurrfetch next from pcurr into @customer

while (@@fetch_status = 0)begin

 print (@customer)  fetch next from pcurr into @customer

end

close pcurrdeallocate pcurr 

 

运行后, 输出结果如下:

（所影响的行数为 91 行）

Alfreds Futterkiste Ana Trujillo Emparedados y helados Antonio Moreno Taquería Around the Horn Berglunds snabbkö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 Familia Arquibaldo FISSA Fabrica Inter. Salchichas S.A. Folies gourmandes Folk och fä HB France restauration Franchi S.p.A. Frankenversand Furia Bacalhau e Frutos do Mar Galería del gastrónomo Godos Cocina Típica Gourmet Lanchonetes Great Lakes Food Market GROSELLA-Restaurante ...... (以下略) ..................................

转载于:https://www.cnblogs.com/HappyQQ/articles/1026506.html

相关资源：数据结构—成绩单生成器