April 16, 2011 at 3:50 pm
Comments posted to this topic are about the item Money and Decimal Datatypes
April 16, 2011 at 3:51 pm
April 17, 2011 at 12:59 am
Nice question, thanks.
M&M
April 17, 2011 at 1:00 pm
Good question.
April 17, 2011 at 11:44 pm
Great question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 17, 2011 at 11:58 pm
good question, thanks.:-)
April 18, 2011 at 12:00 am
Good Question
Thanks
April 18, 2011 at 1:13 am
It's a good habit always to specify precision and scale because of changing default in future releases.
April 18, 2011 at 2:12 am
Of course strictly speaking the result will be 90.3400 as the result will be of type money 🙂
April 18, 2011 at 3:02 am
Easy point today. Love straight-forward questions.
April 18, 2011 at 3:36 am
Thanks for a good question.
April 18, 2011 at 6:48 am
DOH! I clicked too fast. Good question.
April 18, 2011 at 8:26 am
I knew the decimal would have zero places past the decimal but I thought it would round the ANSWER, not just that part of the expression, since it was an expression with 2 different datatypes. I need to do more expressions with mixed datatypes.
Great question!
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
April 18, 2011 at 9:03 am
I wish you would have asked about a SET @dvalue = 10.12
Even though I got the answer correct the 10.10 clouds weather the (10) or the (.10) is the number being stored.
good question! Peace
April 18, 2011 at 9:16 am
Thanks for the question.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 15 posts - 1 through 15 (of 24 total)
You must be logged in to reply to this topic. Login to reply