The dotted table

Question

The dotted table

Steve Jones - SSC Editor

SSC Guru

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

#73656

Comments posted to this topic are about the item The dotted table
November 23, 2015 at 11:29 pm

This was removed by the editor as SPAM

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: 104773 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: 18726 More actions · Answer 2

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

...

Eirikur Eiriksson SSC Guru Points: 182882 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: 259085 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: 64780 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: 287024 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: 11358 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: 183698 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: 11358 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.