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
游标样例
最新推荐文章于 2024-03-28 13:45:00 发布