Schema & Renaming Fun

Question

Schema & Renaming Fun

Andy Warren

SSC Guru

Points: 119902
More actions
March 11, 2014 at 9:14 pm

#150080

Comments posted to this topic are about the item Schema & Renaming Fun
Andy
Connect with me on LinkedIn

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

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

free_mascot One Orange Chip Points: 27164 More actions · Answer 1

Good Question. Getting +2 questions continuous in a row

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

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 2

Thanks for the question.

You have given a hint in QOD to select one option out of 3.

--CLEANUP:
--use master
--drop database xSchemingFun
--drop login qodschemingfun

The above hint tells that database and login will be created successfully.

Carlo Romagnano SSC-Insane Points: 22755 More actions · Answer 3

"Schema cannot be named Not" ?????

"It could be said the table is not funny" ????

Bad wording?

Hany Helmy SSChampion Points: 13921 More actions · Answer 4

pmadhavapeddi22 (3/12/2014)
Thanks for the question.
You have given a hint in QOD to select one option out of 3.
--CLEANUP:
--use master
--drop database xSchemingFun
--drop login qodschemingfun
The above hint tells that database and login will be created successfully.

+ 1

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Koen Verbeeck SSC Guru Points: 259165 More actions · Answer 5

Great question, thanks!

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

Toreador SSChampion Points: 11377 More actions · Answer 6

Interesting question, just a shame that it's let down (as QOTDs so often are) by case inconsistencies.

On a case sensitive database you get several errors and end up with a table called "ny".

palotaiarpad SSCertifiable Points: 5617 More actions · Answer 7

Hmmm.

According to BOL 'not.funny' should be treated as a failure:

[ @newname = ] 'new_name'
Is the new name for the specified object. new_name must be a one-part name and must follow the rules for identifiers. newname is sysname, with no default.

Or does it mean, no space allowed in new_name?

OCTom SSChampion Points: 11785 More actions · Answer 8

I found this to be fun and funny and not very .not.funny.

I was first screaming about the scheming. After I realized what was up, it brought a smile to my face.

Tom

Carlo Romagnano SSC-Insane Points: 22755 More actions · Answer 9

palotaiarpad (3/12/2014)
Hmmm.
According to BOL 'not.funny' should be treated as a failure:
[ @newname = ] 'new_name'
Is the new name for the specified object. new_name must be a one-part name and must follow the rules for identifiers. newname is sysname, with no default.
Or does it mean, no space allowed in new_name?

'not.funny' is just a name as [not.funny].

Andy Warren SSC Guru Points: 119902 More actions · Answer 10

Thanks for the comment on the hint in the cleanup - good catch for you, dumb mistake for me:-)

Andy
Connect with me on LinkedIn

Andy Warren SSC Guru Points: 119902 More actions · Answer 11

I'll try to remember the case sensitivity going forward and add it to my list of things to check.

Andy
Connect with me on LinkedIn

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

Thanks Andy. On a not.funny note, this was a good question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events