分页SQL命令
alter proc query
@tblName varchar(20),--表名
@column varchar(100),--条件列
@rowTop int=4,--每页显示个数
@page int=2,--页数
@selectColumnvarchar varchar(20)='*',--查询的列
@columnOrderby varchar(20)='desc' --排序方式
as
declare @result varchar(max)
set @result='select top '+convert(nvarchar,@rowTop)+' '+@selectColumnvarchar +' from ' +@tblName+
' where ' +@column+ ' not in(select top '+ convert(nvarchar,(@page-1)*@rowTop) +' '+@column+ ' from '
+@tblName+ ' order by '+@column+' '+@columnOrderby+')order by '+@column+' '+@columnOrderby
exec(@result)
exec query 'foodInfo', 'foodID'
alter proc query
@tblName varchar(20),--表名
@column varchar(100),--条件列
@rowTop int=4,--每页显示个数
@page int=2,--页数
@selectColumnvarchar varchar(20)='*',--查询的列
@columnOrderby varchar(20)='desc' --排序方式
as
declare @result varchar(max)
set @result='select top '+convert(nvarchar,@rowTop)+' '+@selectColumnvarchar +' from ' +@tblName+
' where ' +@column+ ' not in(select top '+ convert(nvarchar,(@page-1)*@rowTop) +' '+@column+ ' from '
+@tblName+ ' order by '+@column+' '+@columnOrderby+')order by '+@column+' '+@columnOrderby
exec(@result)
exec query 'foodInfo', 'foodID'