For fun, a quick demonstration

😎

/* 250 Gb */

DECLARE @MY_NumberOfBytes NUMERIC(12,0) = 268435456000;

/* bytes */

SELECT

'Bytes' AS UNIT

,@MY_NumberOfBytes AS NUMBER

UNION ALL

/* Kilobytes, divide by 2^10 (1024) */

SELECT

'Kilobytes' AS UNIT

,@MY_NumberOfBytes / POWER(2.0,10.0) AS NUMBER

UNION ALL

/* Megabytes, divide by 2^20 (1048576) */

SELECT

'Megabytes' AS UNIT

,@MY_NumberOfBytes / POWER(2.0,20.0) AS NUMBER

UNION ALL

/* Gigabytes, divide by 2^30 (1073741824) */

SELECT

'Gigabytes' AS UNIT

,@MY_NumberOfBytes / POWER(2.0,30.0) AS NUMBER

UNION ALL

/* Terabytes, divide by 2^40 (1099511627776) */

SELECT

'Terabytes' AS UNIT

,@MY_NumberOfBytes / POWER(2.0,40.0) AS NUMBER;

Results

UNIT NUMBER

--------- ----------------------

Bytes 268435456000.000000000

Kilobytes 262144000.000000000

Megabytes 256000.000000000

Gigabytes 250.000000000

Terabytes 0.244140625