关键代码如下所示：
sql;">
DECLARE @tb1 Table
(
drive varchar(20),[MB 可用空间] varchar(20)
)
INSERT INTO @tb1
Exec master.dbo.xp_fixeddrives
select drive,CAST( CAST((CAST([MB 可用空间] as decimal(9,2))/1024 ) as decimal(9,2)) as varchar)+'G' as 剩余空间 from @tb1
原文链接：https://www.f2er.com/mssql/62815.html