随笔分类 -  sql server

摘要:https://zhuanlan.zhihu.com/p/92654574 阅读全文
posted @ 2020-12-06 18:20 一叶知秋。 阅读(123) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2018-10-10 14:59 一叶知秋。 阅读(8346) 评论(0) 推荐(0)
摘要://查询所有表明 select name from sysobjects where xtype='u' select * from sys.tables //查询数据库中所有的表名及行数 SELECT a.name, b.rows FROM sysobjects AS a INNER JOIN s 阅读全文
posted @ 2018-06-26 09:02 一叶知秋。 阅读(54841) 评论(1) 推荐(3)