SqlServer游标例子

Declare @Age intDeclare @Name varchar(20)Declare Cur Cursor For Select Age,Name From T_User   Open CurFetch next From Cur Into @Age,@NameWhile @@fetch_status=0     Begin    Update T_User Set [Name]=@Name,Age=@Age    Fetch Next From Cur Into @Age,@NameEnd   Close Cur   Deallocate Cur