s3 sql 分页

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]