SQl SERVER 2000 ±éÀú±íÖÐÊý¾ÝµÄ·½·¨

·½·¨Ò»£ºÊ¹ÓÃÓαê
declare @ProductName nvarchar(50)
declare pcurr cursor for select ProductName from Products
open pcurr
fetch next from pcurr into @ProductName
while (@@fetch_status = 0)
begin
print (@ProductName)
fetch next from pcurr into @ProductName
end
close pcurr
deallocate pcurr
´Ë·½·¨ÊÊÓÃËùÓÐÇé¿ö£¬¶Ô±ê½á¹¹Ã»ÓÐÌØÊâÒªÇó¡£
·½·¨¶þ£ºÊ¹ÓÃÑ­»·
declare @ProductName nvarchar(50)
declare @ProductID int
select @ProductID=min(ProductID) from Products
while @ProductID is not null
begin
select @ProductName=ProductName from Products where
ProductID=@ProductID
print(@ProductName);
select @ProductID=min(ProductID) from Products where
ProductID>@ProductID
end
´Ë·½·¨ÊÊÓÃÓÚ±í´øÓÐ×Ô¶¯Ôö¼Ó±êʶµÄ×Ö¶Î