摘要: 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 阅读全文
posted @ 2011-06-20 22:56 cherry0917 阅读(94) 评论(0) 推荐(0) 编辑