谢谢邹健,我试过了,还是出错。 select top 20 a.*,b.name,u.nickname,u.shownick from articles a inner join area b on a.BELONG_TO=b.id inner join users u on a.AUTHOR_ID = u.id where b.category=87420 and a.REPLY_TO is null order by a.last_update desc除了b.category=59386 ,别的栏目都没问题。1540这个错误信息我在帮助里面查不到
可能是a.*有问题,里面有Text的字段,但是后面并没有用到,我只把要用的字段列出来,问题就没有出现了。谢谢你! select top 20 a.ID,a.TITLE, a.AUTHOR_ID,a.AUTHOR_NAME ,a.AUTHOR_TEXT,a.click_count , a.LAST_UPDATE ,a.LINKURL ,a.LINKIMG ,a.reply_count,a.TopTime, a.Type ,b.name,u.nickname,u.shownick from articles a inner join area b on a.BELONG_TO=b.id inner join users u on a.AUTHOR_ID = u.id where b.category=59386 and a.REPLY_TO is null order by a.last_update desc
select top 20 a.*,b.name,u.nickname,u.shownick from articles a inner join area b on a.BELONG_TO=b.id inner join users u on a.AUTHOR_ID = u.id where b.category=87420 and a.REPLY_TO is null order by a.last_update desc除了b.category=59386 ,别的栏目都没问题。1540这个错误信息我在帮助里面查不到
对象 'ARTICLES' 有 86031 行,这些行位于 5432 页中。
DBCC 执行完毕。如果 DBCC 输出了错误信息,请与系统管理员联系。这应该不算错误
select top 20 a.ID,a.TITLE, a.AUTHOR_ID,a.AUTHOR_NAME ,a.AUTHOR_TEXT,a.click_count , a.LAST_UPDATE ,a.LINKURL ,a.LINKIMG ,a.reply_count,a.TopTime, a.Type ,b.name,u.nickname,u.shownick from articles a inner join area b on a.BELONG_TO=b.id inner join users u on a.AUTHOR_ID = u.id where b.category=59386 and a.REPLY_TO is null order by a.last_update desc