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]
