Approximate Data types

Question

Post reply

Approximate Data types

SQL_kode_kracker

Right there with Babe

Points: 732
More actions
February 15, 2015 at 1:14 am

#315278

Comments posted to this topic are about the item Approximate Data types

Viewing 15 posts - 1 through 15 (of 23 total)

You must be logged in to reply to this topic. Login to reply

Hany Helmy SSChampion Points: 13921 More actions · Answer 1

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

Toreador SSChampion Points: 11376 More actions · Answer 2

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:

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 3

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.

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 4

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

Richard Warr SSCertifiable Points: 6968 More actions · Answer 5

If you're trying to store the value of Pi, then they all are

SqlMel SSCrazy Points: 2901 More actions · Answer 6

SqlMel

SSCrazy

Points: 2901

February 16, 2015 at 5:10 am

#1777790

Good question. Thanks!

---------------
Mel.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 7

Nice question. It never hurts to remind ourselves of the basics.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Xavon SSCrazy Points: 2280 More actions · Answer 8

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:

Umer Akram SSC-Insane Points: 22209 More actions · Answer 9

nice question. good basic knowledge.

thanks for sharing

Sean Lange SSC Guru Points: 286602 More actions · Answer 10

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/

RK Mandava SSCarpal Tunnel Points: 4153 More actions · Answer 11

RK Mandava

SSCarpal Tunnel

Points: 4153

February 16, 2015 at 7:57 am

#1777839

Nice Question, Thanks

SQLDoubleG Hall of Fame Points: 3100 More actions · Answer 12

Koen Verbeeck (2/16/2015)
Easy question, thanks.
Some resources might be appreciated.

BOL

https://msdn.microsoft.com/en-GB/library/ms187752.aspx

TomThomson SSC Guru Points: 104773 More actions Follow · Answer 13

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

Sean Lange SSC Guru Points: 286602 More actions · Answer 14

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/

Approximate Data types

Cookies on SQLServerCentral