[转]sql利用游标循环,遍历表循环结果集
摘要:用 游标(Cursor) + While循环 的方法, 对Customers表中的CompanyName列进行遍历declare @customer nvarchar(50)declare pcurr cursor forselect distinct companyname from customersopen pcurrfetch next from pcurr into @customerwhile (@@fetch_status = 0)begin print (@customer) fetch next from pcurr into @customerendclose pcurr.
阅读全文
posted @ 2013-06-20 16:35