Scaled-down SQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Duncan Pryde » Scaled-down SQL

47 posts, Page 1 of 5

1 2 3 4 5 »»»

Scaled-down SQL

Rate Topic

Display Mode

Topic Options

Author

Message

Duncan Pryde

Posted Saturday, March 19, 2011 12:24 PM

Hall of Fame

Group: General Forum Members
Last Login: Friday, June 14, 2013 2:30 AM
Points: 3,063, Visits: 1,335

Comments posted to this topic are about the item Scaled-down SQL

Post #1080873

bitbucket-25253

Posted Sunday, March 20, 2011 8:38 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:49 PM
Points: 5,122, Visits: 20,362

Excellent question and a more than excellent explanation of why the correct answer is what it is.

Thanks -

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read
Before posting a performance problem please read

Post #1080986

Duncan Pryde

Posted Sunday, March 20, 2011 11:58 AM

Hall of Fame

Group: General Forum Members
Last Login: Friday, June 14, 2013 2:30 AM
Points: 3,063, Visits: 1,335

bitbucket-25253 (3/20/2011)

Excellent question and a more than excellent explanation of why the correct answer is what it is.

Thanks - high praise indeed! I must mention though, that when trying to decide how to format the explanation, I came across this excellent post from SQL Kiwi (Paul White?) - which helped me considerably to come up with a clearer and more concise one than I would have done otherwise.

Cool

Post #1081005

tilew-948340

Posted Sunday, March 20, 2011 6:22 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 8:28 PM
Points: 555, Visits: 2,137

I am sorry, but I realy, realy don't understand why D is not good, even if I do your formula.

Why is so that D would have a truncate answer and not C?
I mean, both have a precision of 51 and only the scale is different (3 more digit more for C), which might explain something if you could explain my question here:

If I declare D as precision of 23 instead of 25 and still having a scale of 10
DECLARE @value1D DECIMAL(23,10), @value2D DECIMAL(23,10)
it is still a precision over 38, and the scale is still 20 as previous, but the answer is not truncate
Why??? Crazy

Post #1081052

UMG Developer

Posted Sunday, March 20, 2011 10:46 PM

SSCrazy

Group: General Forum Members
Last Login: Today @ 2:49 PM
Points: 2,163, Visits: 2,150

Thanks for the question, it really does show why we need to pay close attention to the data types we use.

Post #1081079

Nakul Vachhrajani

Posted Sunday, March 20, 2011 10:53 PM

Ten Centuries

Group: General Forum Members
Last Login: Monday, June 10, 2013 6:56 AM
Points: 1,282, Visits: 1,613

Excellent question, with an excellent (If I may dare say, better than BOL) explanation!

Have a wonderful day!

Thanks & Regards,
Nakul Vachhrajani.
http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.

Follow me on
Twitter: @nakulv_sql
Google Plus: +Nakul

Post #1081080