Paging stored procedures, connection queries

CREATE PROC Innerproc (@pageIndex INT, @pageSizeint) Asbegin DECLARE @strQureySql NVARCHAR ( +)  --Query Statement DECLARE @strStartdNum VARCHAR ( -)                                    --DECLARE @strEndNum VARCHAR ( -) SET @strStartdNum[Email protected]* (@pageIndex-1)+1SET @strEndNum[Email protected]*@pageSize SET @strQureySql='    Select* from (        SelectRow_number () over (ORDER by sm.id Desc) asNumber , Sm.id smid,sm.fatherid,sm.title,smf.id SMFID,SMF. sysmenu_id from Sysmenu SM left JOIN sysmodulefunction SMF on Sm.id=SMF. sysmenu_id) TwhereNumber between'[email protected] +'and'[email protected] +"'EXEC (@strQureySql) PRINT (@strQureySql) endexec Innerproc2,TenDROP PROC Innerproc

Paging stored procedures, connection queries