declare @pagenum int = 1;declare @pagesize int = 3;WITH Tmp AS (SELECTROW_NUMBER() OVER (ORDER BY uid ASC) AS colnum,uid,unameFROM dbo.users o1)SELECT uid,uname FROM TmpWHERE colnum(@pagenum-1)*@pagesize AND colnum=@pagenum*@pagesize;
declare @pagenum int = 1;declare @pagesize int = 3;WITH Tmp AS ( SELECT ROW_NUMBER() OVER (ORDER BY uid ASC) AS colnum, uid, uname FROM dbo.users o1)SELECT uid,uname FROM TmpWHERE colnum>(@pagenum-1)*@pagesize AND colnum<=@pagenum*@pagesize;，香港空间，香港虚拟
本文来源gaodai^.ma#com搞#代!码网
主机，虚拟主机
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：SQLServer2005+分页SQL
转载请注明原文链接：SQLServer2005+分页SQL
