SQL

 获取表的所有字段名 select name from syscolumns where id=object_id('RS_LX_GoodList') //RS_LX_GoodList 为表名

获取每个字段的统计数 select count(1) 统计数 from syscolumns where id=object_id('表名')

按时间的排序

 升序排序  select * from tableName order by time DESC;

降序排序  select * from tableName order by time asc;

 

查询一个数据库有多少表 SELECT count(*) FROM sysobjects WHERE (xtype = 'U')