Legal/illegal characters in table name

Question

Legal/illegal characters in table name

sendijunk

SSChasing Mays

Points: 611
More actions
April 7, 2015 at 9:45 pm

#306721

Comments posted to this topic are about the item Legal/illegal characters in table name
April 8, 2015 at 2:07 am

This was removed by the editor as SPAM

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

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

MyDoggieJessie SSC-Forever Points: 44486 More actions · Answer 1

This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

Carlo Romagnano SSC-Insane Points: 22680 More actions · Answer 2

MyDoggieJessie (4/7/2015)
This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

+1

Ahi, ahi, ahi, ahi, ahi, ahi!!!!!!!!!!

:w00t:

dbafromthecold@gmail.com SSChampion Points: 10160 More actions · Answer 3

MyDoggieJessie (4/7/2015)
This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

Yep:-

Msg 2760, Level 16, State 1, Line 1

The specified schema name "tmp" either does not exist or you do not have permission to use it.

free_mascot One Orange Chip Points: 27169 More actions · Answer 4

Carlo Romagnano (4/8/2015)
MyDoggieJessie (4/7/2015)
This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.
+1
Ahi, ahi, ahi, ahi, ahi, ahi!!!!!!!!!!
:w00t:

+1

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Mauricio_ SSCrazy Points: 2935 More actions · Answer 5

Mauricio_

SSCrazy

Points: 2935

April 8, 2015 at 1:09 am

#1789424

+1

I was going to write exactly the same 🙂

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 6

Nice question, but a bit of an oversight on the tmp schema.

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

Bhaskar.Shetty Hall of Fame Points: 3054 More actions · Answer 7

Bhaskar.Shetty

Hall of Fame

Points: 3054

April 8, 2015 at 1:37 am

#1789435

Same Here.. +1

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 8

Thanks for the post, good one.

I was of sure of usage of square brackets will lead to the successful table creation, and that "tmp." schema name- as not all databases will have it, so I thought "well yea... error".

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 9

Good question. Possible but not practical.

Igor Micev,My blog: www.igormicev.com

Sean of the Lynchmob Ten Centuries Points: 1038 More actions · Answer 10

I got this when I ran it:

Msg 2760, Level 16, State 1, Line 1

The specified schema name "tmp" either does not exist or you do not have permission to use it.

.....and no table created. So I have to disagree with the "correct" answer.....

Toreador SSChampion Points: 11368 More actions · Answer 11

Like some others, I guessed wrongly that the "trick" to this question was about the schema 🙁

Hany Helmy SSChampion Points: 13921 More actions · Answer 12

MyDoggieJessie (4/7/2015)
This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

+1, this should have been mentioned in the question.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Hany Helmy SSChampion Points: 13921 More actions · Answer 13

Stewart "Arturius" Campbell (4/8/2015)
Good question, despite the tmp schema "issue"
Highlights the difference between what is possible and what is practical.

True, this is possible but not practical @ all, who will ever think about naming a table (char(13))?! 😀

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant