Code
alter proc UserInfos_SelectAllPaged
@pageCount int,   --每页显示的条数
@pageNow int,     --当前页数
@tableName varchar(50),  --表名
@primaryName varchar(50),  --表主键的名字
@condition varchar(500),   --搜索条件
@Count int output        --返回总记录数
as
declare @sql nvarchar(2000)
declare @sqlcount varchar(500)
declare @strFilters nvarchar(500)
set @strFilters = @condition
declare @countTemp int 
if(@condition = '')    --无条件搜索,默认为空
begin
  set @sql = 'select top ' + cast(@pageCount as varchar) + ' * from ' + @tableName+ 
' where ' + @primaryName + ' not in (select top ' + cast(@pageCount*(@pageNow-1) as varchar) + ' ' + @primaryName + ' from '+ @tableName+')'
exec(@sql)
end
else
begin
  set @sql = 'select top ' + cast(@pageCount as varchar) + ' * from ' + @tableName+ 
' where ' + @primaryName + ' not in (select top ' + cast(@pageCount*(@pageNow-1) as varchar) + ' ' + @primaryName + ' from '+ @tableName+')' + 
' and ' + @strFilters
exec(@sql)
end
SET @sql=N'SELECT @countTemp=COUNT(*)' +N' FROM '+@tableName 
EXEC sp_executesql @sql,N'@countTemp int OUTPUT',@countTemp OUTPUT 
set @Count = @countTemp