February 15, 2015 at 1:14 am
Comments posted to this topic are about the item Approximate Data types
February 15, 2015 at 1:45 am
Nice question, thanx, knew the answer but was not sure, so made some R&D on it.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
February 16, 2015 at 1:22 am
Owing to the absence of a "select two" hint I almost went for "all of the above", but saw sense and got it right.
I've obviously been doing these QotD for too long :rolleyes:
February 16, 2015 at 1:36 am
Thank you for the post, good one.
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 16, 2015 at 2:29 am
Easy question, thanks.
Some resources might be appreciated.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 16, 2015 at 2:43 am
If you're trying to store the value of Pi, then they all are
February 16, 2015 at 5:10 am
Good question. Thanks!
---------------
Mel.
February 16, 2015 at 6:10 am
Nice question. It never hurts to remind ourselves of the basics.
February 16, 2015 at 6:29 am
Richard Warr (2/16/2015)
If you're trying to store the value of Pi, then they all are
Nah, just declare DECIMAL(8,8). And get a really big hard drive.
:hehe:
February 16, 2015 at 7:27 am
nice question. good basic knowledge.
thanks for sharing
February 16, 2015 at 7:49 am
Great back to basics question. I am shocked at the response rate.
Correct answers: 57% (166)
Incorrect answers: 43% (123)
Total attempts: 289
I am really surprised that so many people got this wrong. Obviously this is a topic which needs some more attention if this many people are confused about what is an exact numeric and approximate. :w00t:
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
February 16, 2015 at 7:57 am
Nice Question, Thanks
February 16, 2015 at 9:00 am
Koen Verbeeck (2/16/2015)
Easy question, thanks.Some resources might be appreciated.
BOL
February 16, 2015 at 10:42 am
Sean Lange (2/16/2015)
Great back to basics question. I am shocked at the response rate.Correct answers: 57% (166)
Incorrect answers: 43% (123)
Total attempts: 289
I am really surprised that so many people got this wrong. Obviously this is a topic which needs some more attention if this many people are confused about what is an exact numeric and approximate. :w00t:
I don't think it's particularly surprising, it's quite natutral that a lot of eople don't remember this bizarre misuse of the word "approximate". In fact I would agree with Richard Warr if this nonsensical mis-naming wasn't clearly documented. It's somewhat encouraging that more than half of the wrong answers so far were "all of the above".
Tom
February 16, 2015 at 11:58 am
TomThomson (2/16/2015)
Sean Lange (2/16/2015)
Great back to basics question. I am shocked at the response rate.Correct answers: 57% (166)
Incorrect answers: 43% (123)
Total attempts: 289
I am really surprised that so many people got this wrong. Obviously this is a topic which needs some more attention if this many people are confused about what is an exact numeric and approximate. :w00t:
I don't think it's particularly surprising, it's quite natutral that a lot of eople don't remember this bizarre misuse of the word "approximate". In fact I would agree with Richard Warr if this nonsensical mis-naming wasn't clearly documented. It's somewhat encouraging that more than half of the wrong answers so far were "all of the above".
I'm not sure I agree that it is "nonsensical mis-naming". What should they be called then to live up to your standards for naming?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 15 posts - 1 through 15 (of 23 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy