Create PROCEDURE usp_Common_Paging ( @tablename nvarchar(255),--操作的表名 @pagesize int,--单页显示个数 @pageindex int,--当前页码 @condition nvarchar(1000),--筛选条件,格式: a=1 and b=2 @primarykey nvarchar(255),--主键,格式: id @order nvarchar(255)--排序,格式: id desc,id2 desc ) AS DECLARE @sqlcount nvarchar(2000) DECLARE @sql nvarchar(2000) DECLARE @orderby nvarchar(255) SET @orderby = ISNULL(@order,@primarykey) IF(LEN(@orderby)=0) SET @orderby=@primarykey SET @orderby=' '+@orderby SET @sql='WITH temptbl AS (' SET @sql=@sql+'Select ROW_NUMBER() OVER (ORDER BY '+@orderby+')AS ROW_NUM, * from '+@tablename set @sqlcount='Select count(0) FROM '+@tablename IF(LEN(ISNULL(@condition,''))>0) BEGIN set @sqlcount=@sqlcount+ ' where ' + @condition set @sql=@sql+ ' where ' + @condition End DEclARE @rowstart nvarchar(20),@rowend nvarchar(20) if(@pageindex<1) SET @pageindex=1 SET @rowstart=(@pageindex-1)*@pagesize+1 SET @rowend=CAST((@pageindex-1)*@pagesize+@pagesize as nvarchar(20)) set @sql=@sql+')Select * FROM temptbl where ROW_NUM between '+@rowstart+' and '+@rowend EXECUTE sp_executesql @sql EXECUTE sp_executesql @sqlcount GO