通用分页存储过程(SQL SERVER)

 ------------------------------------------------------------------------------------------
-- 通用分页存储过程
-- 作者：罗军林
-- 建立时间：2007-6-11
-- 需要如下需数：
-- @pageNum,@pageSize,@primaryKey,@tableName,@conditions
-- 页码      每页行数   表的主键 表名   条件，可不填
------------------------------------------------------------------------------------------
if exists(select * from sysobjects where name='proc_page_query')
 drop proc proc_page_query
go
create proc proc_page_query @pageNum int,@pageSize int,@primaryKey varchar(20),@tableName varchar(20),@conditions varchar(100)=' 1=1 '
as
 begin
  declare @sql varchar(254)
  
  set @sql='select top '+convert(varchar,@pageSize) + ' *  from '+@tableName+' where '+@conditions+' and '+@primaryKey+' not in
   ('+'select top '+convert(varchar,(@pageNum-1)*@pageSize) +'  '+@primaryKey +' from '+@tableName+' order by '+@primaryKey
   +') order by '+@primaryKey
  print @sql
  exec(@sql)
 end
go