The dotted table

Question

The dotted table

Steve Jones - SSC Editor

SSC Guru

Points: 738632
More actions
November 23, 2015 at 9:10 pm

#73656

Comments posted to this topic are about the item The dotted table

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

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

TomThomson SSC Guru Points: 104768 More actions · Answer 1

Nice question.

But your "not necessarily recommended" is a bit less emphatic than my expression would be if I encountered something like this in a code review. :rolleyes:

Tom

HappyGeek SSCoach Points: 18729 More actions · Answer 2

Nice simple question, valid it may be but certainly not to be recommended. Thanks Steve.

...

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 3

TomThomson (11/23/2015)
Nice question.
But your "not necessarily recommended" is a bit less emphatic than my expression would be if I encountered something like this in a code review. :rolleyes:

+1

😎

Certainly drop the code most probably something else along with it........

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

Easy one, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Hany Helmy SSChampion Points: 13921 More actions · Answer 5

Yes valid, but definitely not recommended, I hope that MS will prevent this code from being created by mistake in future releases.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Louisa Whitton SSCrazy Points: 2577 More actions · Answer 6

According to Chambers Dictionary, the definition of "wrong" includes:

"not appropriate or suitable"

"not good or sensible; unjustifiable"

"amiss, causing trouble, pain, etc"

"not socially acceptable"

I think you could make a case for the "dotted table" being wrong on all these counts!

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 7

The correct answer is missing: "The table doesn't have a primary key". It's also suspect that all columns are nullable.

From the answer options I deduced that I needed to focus on the table name only; perhaps you can change the question text to reflect that?

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

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

I have to agree with Tom. It may be valid, but is certainly not recommended and it would never survive a review.

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

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 9

I tried creating a #table and it didn't like the periods.

Toreador SSChampion Points: 11384 More actions · Answer 10

Iwas Bornready (11/24/2015)
I tried creating a #table and it didn't like the periods.

The # needs to be inside the brackets

CREATE TABLE [#this.is.a.test]

Luis Cazares SSC Guru Points: 183706 More actions · Answer 11

Maybe "What's wrong with this table?" should be change to something like "What's wrong with the syntax of this statement to create a table"?

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Toreador SSChampion Points: 11384 More actions · Answer 12

The following will also work

CREATE TABLE [.[[.[[.[[.]].]].]].]]]

( myid INT

, mychar VARCHAR(200)

);

or

CREATE TABLE [[[[[[[]]]]]]]]]

( myid INT

, mychar VARCHAR(200)

);

or

CREATE TABLE [You Are Fired!]

( myid INT

, mychar VARCHAR(200)

);

DonlSimpson SSCertifiable Points: 7043 More actions · Answer 13

martin.whitton (11/24/2015)
According to Chambers Dictionary, the definition of "wrong" includes:
"not appropriate or suitable"
"not good or sensible; unjustifiable"
"amiss, causing trouble, pain, etc"
"not socially acceptable"
I think you could make a case for the "dotted table" being wrong on all these counts!

+1

Don Simpson

I'm not sure about Heisenberg.

sknox SSChampion Points: 12388 More actions · Answer 14

Hany Helmy (11/24/2015)
Yes valid, but definitely not recommended, I hope that MS will prevent this code from being created by mistake in future releases.

How would you propose to do that, without affecting other valid, probably not recommended either, but sometimes necessary or useful forms?

Unnecessary restriction is no substitute for due diligence in coding and review.