游标样例

 declare @upid int
set @upid=10


declare @str nvarchar(256)
set @str=''
declare cur cursor
for select upid from hj_class_news

open cur
fetch cur into @upid-------------------
while @@fetch_status=0
begin
set @str=@str + cast(@upid as  nvarchar(256))
set @str=@str  + ','
fetch cur into @upid---------------------
end

close cur
deallocate cur

select @str