select top 1000 locktopic,boardid,rootid,announceid,body,Expression,topic,username,dateandtime,postuserid,ParentID from (select * from bbs1 union all
select * from bbs2 union all
select * from bbs3 union all
select * from bbs4) t where username='楼上的客人' and locktopic<2 ORDER BY announceID desc
select * from bbs2 union all
select * from bbs3 union all
select * from bbs4) t where username='楼上的客人' and locktopic<2 ORDER BY announceID desc
select * from bbs2 union all
select * from bbs3 union all
select * from bbs4) t where username='楼上的客人' and locktopic<2 ORDER BY announceID desc
服务器: 消息 8626,级别 16,状态 1,行 1
在工作表中只允许有 text 指针,而决不允许有 text、ntext 或 image 列。查询处理器生成的查询计划要求在工作表中有 text、ntext 或 image 列。