SQL query server hard disk space remaining, SQL query server remaining

SQL query server hard disk space remaining, SQL query server remaining

The key code is as follows:

DECLARE @ tb1 Table (drive varchar (20), [MB available space] varchar (20) insert into @ tb1 Exec master. dbo. xp_fixeddrivesselect drive, CAST ([MB available space] as decimal (1024)/) as decimal () as varchar) + 'G' as remaining space from @ tb1

The above describes the remaining space on the hard disk of the SQL query server. I hope it will be helpful to you. If you want to learn more, please stay tuned for help!