SqlÓï¾äÆ´½Ó

SQL´úÂ룺

declare @sql varchar(1000)
declare @tablename varchar(100)
declare @filter varchar(100)
declare @Startindex int
declare @PageSize int
set @tablename='userlist'
set  @filter='1=1'
set @PageSize=5
set @Startindex=1
set @sql='with temptable as ( select row_number() over(order by id) rowid,* from  '+@tablename+' where '+@filter+' )
select * from temptable where rowid between '+@Startindex+' and '+@PageSize+'+'+@Startindex+'-1'
print @sql

exec(@sql)


±¨´í£º


ÏûÏ¢ 245£¬¼¶±ð 16£¬×´Ì¬ 1£¬µÚ 10 ÐÐ
ÔÚ½« varchar Öµ 'with temptable as ( select row_number() over(order by id) rowid,* from  userlist where 1=1 )
select * from temptable where rowid between ' ת»»³ÉÊý¾ÝÀàÐÍ int ʱʧ°Ü¡£

---

SQL code:

declare @sql varchar(1000)
declare @tablename varchar(100)
declare @filter varchar(100)
declare @Startindex int
declare @PageSize int
set @tablename='userlist'
set @filter='1=1'
set @PageSize=5
set @Startindex=1
set @sql='with temptable as ( select row_number() over(order by id) rowid,* from '+@tablename+' where '+@filter+' )
select * from temptable where rowid between