Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345

A round number Expand / Collapse
Author
Message
Posted Friday, May 07, 2010 10:15 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 7:41 PM
Points: 634, Visits: 399
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;

Post #918123
Posted Friday, May 07, 2010 10:43 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:29 PM
Points: 11,168, Visits: 10,928
Michael Poppers (5/7/2010)
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?

Thank you for your vote Michael - and yes, please feel free to add the comment




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #918445
Posted Monday, May 10, 2010 11:09 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 7:41 PM
Points: 634, Visits: 399
Paul White NZ (5/7/2010)
Michael Poppers (5/7/2010)
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?

Thank you for your vote Michael - and yes, please feel free to add the comment

Done. Thanks.
Post #919192
Posted Sunday, November 07, 2010 4:59 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Sunday, November 17, 2013 11:53 AM
Points: 623, Visits: 237
I didn't get any error. i got 0.00 i wonder why
Post #1016990
« Prev Topic | Next Topic »

Add to briefcase «««12345

Permissions Expand / Collapse