Legal/illegal characters in table name

Question

Legal/illegal characters in table name

Viewing 15 posts - 16 through 30 (of 52 total)

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

l.vignando Old Hand Points: 313 More actions · Answer 1

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.

I agree, I supposed it was a trick: you notice that the name is valid and you do not note that schema is not.

Richard Warr SSCertifiable Points: 6967 More actions · Answer 2

It should have been possible to attempt an answer without just running the code. And, given the title of the question, it should have been clear that the "tmp" error was just an oversight and not really relevant.

Toreador SSChampion Points: 11368 More actions · Answer 3

Richard Warr (4/8/2015)
It should have been possible to attempt an answer without just running the code. And, given the title of the question, it should have been clear that the "tmp" error was just an oversight and not really relevant.

Only if you notice the question title! I always answer via the email, which doesn't include the title. And having read the question in the email, when I click the link my eyes go straight to the answers 🙂

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

This could have been a nice question about an interesting curiosity (though utterly useless, as nobody will ever use this in real life - right?).

Unfortunately, the mishap with the schema name ruins the question. I immediately saw that the correct answer depends on an assumption about the tmp schema, and while pondering which assumption to make noticed the question title. This still didn't convince me fully (there have in the past been questions with very misleading titles), but it did give me enough confidence to assume that the author has a tmp schema and has forgotten that not everyone has.

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/

Toni-256719 SSCertifiable Points: 5927 More actions · Answer 5

The table is not created. The question did not mention anything about the tmp schema existing.

This will fail with an error.

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.

djj SSCoach Points: 18831 More actions · Answer 6

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.

As pointed out.

Charles Hearn SSCrazy Points: 2680 More actions · Answer 7

If only the code had been

declare @sql nvarchar(max)

set @sql = 'IF OBJECT_ID(''TempDB..[' + CHAR(31) + ']'') IS NOT NULL DROP TABLE TempDB..[' + CHAR(31) + ']' + CHAR(10) +

'create table tempdb..[' + char(31) + ']

(

id int

)'

EXECUTE sp_executesql @sql

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

Given the title of the question, I figured the tmp schema was an oversight. After changing the schema to dbo, I found the results simple enough. From there, try to do anything else with the table...interesting.

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

dmoldovan SSCertifiable Points: 6334 More actions · Answer 9

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.

Agree

Bobby Russell SSCrazy Points: 2801 More actions · Answer 10

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.

and again...+1

Another incorrect correct answer. TEST BEFORE POST. 😀

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 11

akljfhnlaflkj

SSC Guru

Points: 76202

April 8, 2015 at 6:53 am

#1789504

I got it wrong. So I tested it. It failed. Hmmmm.

akljfhnlaflkj SSC Guru Points: 76202 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.

Oh, that's why it failed. Thanks for the help.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 13

Koen Verbeeck (4/8/2015)
Nice question, but a bit of an oversight on the tmp schema.

I totally agree.

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

free_mascot (4/8/2015)
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

+1

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

Sean of the Lynchmob (4/8/2015)
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.....

+1