狠狠色丁香婷婷综合尤物/久久精品综合一区二区三区/中国有色金属学报/国产日韩欧美在线观看 - 国产一区二区三区四区五区tv

SQL code

 

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 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  

此方法適用所有情況，對標(biāo)結(jié)構(gòu)沒有特殊要求。

方法二：使用循環(huán)

SQL code

 

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 

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

此方法適用于表帶有自動增加標(biāo)識的字段