Christian Buettner-167247 (5/7/2010)
Paul White NZ (5/6/2010)
Please vote and mark as reproducible if you can.Done 🙂
Ditto.
Paul, isn't it worth noting the different "ThePrecision" results from the sql_variant_property() output noted earlier in this discussion? Would you like me to add the following code snippet as a comment to your Connect submission? Thanks.
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;