存储过程,查询的表本身主键，创建带有主键的临时表；

create table #Temp
  (
          SN int identity(1,1),//创建表时设置主键
          ID INT,
          NAME NVARCHAR(10),
          Mobile NVARCHAR(11),
          Remark NVARCHAR(200)
         )

 INSERT INTO #Temp(ID,NAME,Mobile,Remark) SELECT ID,NAME,Mobile,Remark
FROM Principal
WHERE NAME LIKE '%'+ CASE ISNULL(@Name,'') WHEN '' THEN NAME ELSE @Name END+'%'

 SELECT @RecordCount = COUNT(*) FROM #Temp
 /*计算页面数据*/
 SET @PageCount = CEILING(@RecordCount * 1.0 / @PageSize)
 
 SELECT *
 FROM #Temp
 WHERE  SN <= @PageIndex * @PageSize AND SN > (@PageIndex - 1) * @PageSize
 ORDER BY SN ASC
 --drop
 drop table #Temp
 END