select*from address order by id offset 4 rows fetch next 5 rows only
4从第4条数据以后, 5显示5条 以id为排列
SELECT COUNT(*) FROM sysobjects WHERE (xtype = ‘U’) 查询sql server有多少张表
SELECT count(1) as col_Count FROM syscolumns WHERE id = OBJECT_ID(‘Address’)
查询Address表有多少列