随笔分类 - sql server
摘要:https://zhuanlan.zhihu.com/p/92654574
阅读全文
摘要:1: select sum(c.row_count) as datacount from sys.indexes a , sys.objects b , sys.dm_db_partition_stats c where a.[object_id] = b.[object_id] AND b.[ob
阅读全文
摘要://查询所有表明 select name from sysobjects where xtype='u' select * from sys.tables //查询数据库中所有的表名及行数 SELECT a.name, b.rows FROM sysobjects AS a INNER JOIN s
阅读全文

浙公网安备 33010602011771号