存储过程实现分页效果，返回2个结果集

ALTER PROCEDURE [dbo].[PageList]
(
@PageIndex int,
@PageSize int,
@TableName varchar(2000),
@CoumnName varchar(2000),
@Where varchar(2000),
@OrderBy varchar(500),
@Count int out
)
as
declare @sql nvarchar(4000)
declare @zonghang int  --总行数
set @sql=' select '+@CoumnName+' from '+@TableName+ ' where '+@Where+' order by '+@OrderBy+' desc OFFSET '+ Cast(((@PageIndex-1)*@PageSize) as varchar(200)) + ' ROWS FETCH NEXT '+Cast(@PageSize as varchar(200))+' ROWS ONLY ';

exec(@sql);

set @sql='select @total = count(0)  from '+@TableName+' where '+@Where;
exec sp_executesql @sql,N'@total int out',@zonghang output
set @Count=@zonghang