01 2022 档案

查询数据库所有表数据量
摘要：select b.name,a.row_count from sys.dm_db_partition_stats a, sys.objects b where a.object_id=b.object_id and a.index_id<=1 and b.type='U' ORDER BY row_ 阅读全文
posted @ 2022-01-12 15:24 小杨观世界 阅读(138) 评论(0) 推荐(0) 编辑
Sql Server 取小数点后两位，向上取整，向下取整，四舍五入
摘要：select 2.0983 [值],convert(numeric(8,2),round(2.0983,2)) [取小数点后两位] select 2.0983 [值],cast(2.0983 as decimal(20,2)) [取小数点后两位] select 2.0983 [值],round(2. 阅读全文
posted @ 2022-01-07 10:21 小杨观世界 阅读(2988) 评论(0) 推荐(0) 编辑