摘要:
Declare @Age intDeclare @Name varchar(20)Declare Cur Cursor For SelectAge,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 阅读全文