ALTER procedure [dbo].[KFDABySearchString]
(@searchstr varchar(100),
@pagesize int,
@pageindex int)
as
begin
--with temptbl as (SELECT ROW_NUMBER() OVER (ORDER BY DH desc)AS Row, * from KFDA O where isnull(TM,'') + isnull(ZRZ,'') like '%'+@searchstr+'%')
with temptbl as (SELECT ROW_NUMBER() OVER (ORDER BY DH)AS Row, * from KFDA O where isnull(TM,'') + isnull(ZRZ,'') like @searchstr)
SELECT * FROM temptbl where Row between (@pageindex-1)*@pagesize+1 and (@pageindex-1)*@pagesize+@pagesize
end