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