摘要:有段时间,CSDN的揭帖总随机出些问题,得分人数得分总和小于帖子分数。
揭帖这里,使用了SQL 的游标,核心代码如下:
declare mycursorxx scroll cursor for select ..... FROM .... where ..... order by .... open mycursorxx fetch first from mycursorxx into @PostUserId,@Point,@ReplyID while @@fetch_status = 0 begin ...............fetch NEXT from mycursorxx into @PostUserId,@Point,@ReplyID end
分析进去后,上面的游标定义有并发处理的问题,修改成以下方式就没有了
declare mycursorxx cursor scroll static for select ..... FROM .... where ..... order by .... open mycursorxx fetch first from mycursorxx into @PostUserId,@Point,@ReplyID while @@fetch_status = 0 begin ...............fetch NEXT from mycursorxx into @PostUserId,@Point,@ReplyID end
核心就是把这个游标定义成静态游标,就可以避免上述问题的发生。
参考资料:http://www.stefli.com/blog/blogview.asp?logID=219...[
阅读全文]