SQL技术经验总结
郝伟 2021/10/06

• 常用SQL
  • 数据库全表统计：统计每张表有多少行记录
  • 电源连接字符串

常用SQL

数据库全表统计：统计每张表有多少行记录

SELECT TOP(10)
  schema_name(systable.schema_id) as TableSchema, systable.name as TableName, sysids.rows as NumberOfRows
FROM 
  sys.tables as systable, sysindexes as sysids 
WHERE 
  systable.object_id = sysids.id and sysids.indid <=1 and sysids.rows > 10  
ORDER BY NumberOfRows DESC

返回结果

TableSchema	TableName	NumberOfRows
ACDC	ResultValueString	29207164
ACDC	ResultValueFloat	25033996
ACDC	ResultValueInteger	20862260
ACDC	Graph	8267030
ACDC	GraphBase	8267030
ACDC	ResultToGraph	8266654
ACDC	ResultTightening	4172452
ACDC	ResultIdentification	4172452
ACDC	ResultToJobResult	4172452
ACDC	ResultToTool	4172452

电源连接字符串