top 0 本来就有点别扭,换成下面的得了。select ID from news where 1=2
解决方案 »
- 这两个结果集怎样连起来
- SQLserver 相关的服务都没了。。
- 日期字符串,形如 200712,2007/12 ,这种格式,如何得到前一月,或上一月的字串,如果是datetime型可以用dateadd函数,但是字符串如何办呀?
- SELECT TOP @Number ID FROM ....的存储过程为什么总是提示语法错误??
- 高手请进,关于行列转换动态生成行
- 用uedit32编辑sql文件,如何使它可以突显sql关键字?
- insert语句中含有中文字符的问题
- 请教MSSQL 2000的连接问题
- 存储过程中使用游标出现了问题
- 如何数据库事务备份还原.
- SQL语句求助:变表的列为行
- 高手指点.Sql2005安装的问题
if pagecount>0 then
sql = "select top " & pagecount & " ID,newstitle,posttime,sortid,hits from info where id not in(select top " & pagecount * (Page - 1) & " ID from info where sortid=" & CID & " order by ID desc) and sortid=" & CID & " order by id desc"end if
sql = "select top " & pagecount & " ID,newstitle,posttime,sortid,hits from info where sortid=" & CID & " order by id desc"
Else
sql = "select top " & pagecount & " ID,newstitle,posttime,sortid,hits from info where id not in(select top " & pagecount * (Page - 1) & " ID from info where sortid=" & CID & " order by ID desc) and sortid=" & CID & " order by id desc"
End If这样解决了,不过 为什么select top 0 在Access会出错啊?
Returns a certain number of records that fall at the top or the bottom of a range specified by an ORDER BY clause...
The value that follows TOP must be an unsigned Integer.
就是正整数拉