存储过程游标

最新推荐文章于 2022-04-16 22:07:01 发布

weixin_30340353

最新推荐文章于 2022-04-16 22:07:01 发布

阅读量45

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/snlfq2000/archive/2008/03/08/1096948.html

过程片段:
declare master_cursor CURSOR FOR
select hangbiaoshi from tab_Test order by hangbiaoshi desc
open master_cursor

FETCH NEXT FROM master_cursor into @hangbiaoshi
while @@fetch_status = 0

BEGIN
set @tmpcontent = ''
declare senc_cursor CURSOR FOR
select userName,content,date from tab_information where guanlianbiaoshi = @hangbiaoshi
open senc_cursor
FETCH NEXT FROM senc_cursor into @user,@content,@date
while @@fetch_status = 0
begin

set @tmpcontent = @tmpcontent + @user + ':' + @content + '(' + convert(varchar(50),@date,120) + ')' + '<br>'
FETCH NEXT FROM senc_cursor into @user,@content,@date
end

insert into #resultTable values (@hangbiaoshi,@tmpcontent)

CLOSE senc_cursor
DEALLOCATE senc_cursor

FETCH NEXT FROM master_cursor into @hangbiaoshi
END

CLOSE master_cursor
DEALLOCATE master_cursor

select * from #resultTable

转载于:https://www.cnblogs.com/snlfq2000/archive/2008/03/08/1096948.html