s3 sql 分页

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

exec sp_reset_connection go SELECT TOP 5 * FROM (select ROW_NUMBER() OVER (order by id desc) AS rn__,[id],[shopname] from [shop] ) t where rn__>0 order by rn__ go select count(*) as dc__  from [shop] go exec sp_reset_connection go select * from [shop] with (nolock) where 1=2 go select name,colstat,colorder,IsNullAble,xtype, prec,columnproperty(id, name, 'IsIdentity') as IsIdentity from syscolumns with (nolock) where id=OBJECT_ID('shop') go     SELECT TOP 5 * FROM (select ROW_NUMBER() OVER (order by id desc) AS rn__,[id],[shopname] from [shop] ) t where rn__>5 order by rn__   select count(*) as dc__  from [shop]