[阅读: 1079] 2007-04-10 17:35:07
下面这段SQL生成的结果我想把 while 里面多次 SELECT 出的东西合并到一个结果集中该如何做?
这是我想改进论坛贴子列表的试验SQL
[CODE=SQL]
DECLARE @BlockID AS int
DECLARE msgBlocks CURSOR FOR
SELECT TOP 20 BlockID FROM forum_msgs
WHERE owner_board_name = 'java' AND BlockLayerID = 0 ORDER BY date_msg DESC
OPEN msgBlocks;
FETCH NEXT FROM msgBlocks INTO @BlockID
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT * FROM forum_msgs WHERE BlockID = @BlockID ORDER BY BlockOrderID
FETCH NEXT FROM msgBlocks INTO @BlockID
END;
CLOSE msgBlocks;
DEALLOCATE msgBlocks;
GO
[/CODE]
Notemper2x 3.1 ( ̄ε( ̄#)
没脾气2x 之 个人综合篇:
http://notemper2x.cndev.org/
我的 panoramio 相册:
http://panoramio.com/user/zhaixudong
我的 flickr相册:
http://www.flickr.com/photos/notemper2x/
QQ号20250出售,售价400,000元整(5位、皇冠80级、VIP7)