游标的用法

Declare @Age int
Declare @Name varchar(20)
Declare Cur Cursor For Select Age,Name From T_User  
Open Cur
Fetch next From Cur Into @Age,@Name
While @@fetch_status=0    
Begin
    Update T_User Set [Name]=@Name,Age=@Age
    Fetch Next From Cur Into @Age,@Name
End  
Close Cur  
Deallocate Cur
posted @ 2011-03-08 16:22  从头儿再来  阅读(75)  评论(0)    收藏  举报