SQL Server Cursor

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 @ 2013-03-30 15:11  信息化建设  阅读(334)  评论(0编辑  收藏  举报