Question

在sqlserver 2008中报limit附近有语法错误

select id, username, title, postdate, replies from topic where parentid=0 and forumid=? order by id desc limit ?,?
在sqlserver 2008中报limit附近有语法错误，怎么改啊

Answer 1

limit是mysql的语法，分页的话应该用row_number()函数

Answer 2

SQL Server中取一定条数的数据，采用top

如
select top 100 * from table
表示从table中取出前100条数据

追问

能具体点么

追答

就是这种形式呀

select top 100 id, username, title, postdate, replies from topic where parentid=0 and forumid=? order by id desc

当然在2008以后 top后面的值也可以是一个变量
如declare @top int

set @top =100

select top (@top) id, username, title, postdate, replies from topic where parentid=0 and forumid=? order by id desc