// SQL server
Declare @PageNo int=5,@pageSize int=5
select top (@pageSize) * from(select ROW_NUMBER() OVER(ORDER BY hhguid ASC) as line, * from tblhh where
createdby=94)mm
where line > (@PageNo - 1) * @pageSize
–> To highlight a block of code in Notepad++, please do the following steps step-1 :- Select the required text. step-2 :- Right click...
No comments:
Post a Comment