代码改变世界

SQL利用游标读取列并执行操作

2010-07-09 14:57  飞逝心情  阅读(341)  评论(0)  编辑  收藏  举报 
declare @id int,@name varchar(20);
declare @IDList varchar(5000)
set @IDList=''
declare cur cursor fast_forward for
  select ArticleID,Title from Article;
open cur;
fetch next from cur into @id,@name;
while @@fetch_status=0
begin
   --做你要做的事
  set @IDList=@IDList+' '+convert(varchar(10),@id) 
   fetch next from cur into @id,@name;
end
close cur;
deallocate cur;
print @IDList