select 
        sql_variant_property(cast(1.0 as sql_variant), 'BaseType') BaseType,
        sql_variant_property(cast(1.0 as sql_variant), 'Precision') ThePrecision,
        sql_variant_property(cast(1.0 as sql_variant), 'Scale') Scale;
select 
        sql_variant_property(cast(ROUND(0.5,0) as sql_variant), 'BaseType') BaseType,
        sql_variant_property(cast(ROUND(0.5,0) as sql_variant), 'Precision') ThePrecision,
        sql_variant_property(cast(ROUND(0.5,0) as sql_variant), 'Scale') Scale;