June 19, 2014 at 9:58 pm
Comments posted to this topic are about the item Poecilonym Madness!
June 20, 2014 at 12:31 am
Thanks for question Andy.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
June 20, 2014 at 12:38 am
Thanks for the question
I've missed something about synonym. I need to review the subject
June 20, 2014 at 1:23 am
Interesting question, thank you Andy.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 20, 2014 at 3:01 am
There is nothing indicating if the database setting is case sensitive, our databases are. Therefore I went for different answers than the one seen as correct.
Would I have been correct to say that the synonym would not have been created, the table failed to drop and the view was not created?
June 20, 2014 at 3:20 am
erwin.oosterhoorn (6/20/2014)
There is nothing indicating if the database setting is case sensitive, our databases are. Therefore I went for different answers than the one seen as correct.Would I have been correct to say that the synonym would not have been created, the table failed to drop and the view was not created?
If not otherwise indicated in the question we should assume the server is running with default settings.
Good question.
June 20, 2014 at 3:54 am
This was removed by the editor as SPAM
June 20, 2014 at 4:17 am
Thank you for the post, Andy, good one.
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
June 20, 2014 at 4:25 am
erwin.oosterhoorn (6/20/2014)
There is nothing indicating if the database setting is case sensitive, our databases are. Therefore I went for different answers than the one seen as correct.Would I have been correct to say that the synonym would not have been created, the table failed to drop and the view was not created?
Well... the exchange of thoughts on collation is been going on from very long back, but at the end we all kind of nodded that if the mention of collation is not there then go for default "Latin1_General_CI_AI" (this is just an example and not for debate) - Or in other words drop the collation from the criteria. Sorry for your loss (i mean for points..) Now you know. 🙂
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
June 20, 2014 at 5:09 am
Given the discussions about collation over the years, I assumed that this was a "trick" question on that subject. In which case the correct answer would have been
Table Test is created
Table Test2 is created
The synonym is created
The drop table statement fails
The create view statement fails
The final select fails
It was unfortunate that the options were set in such a way that this configuration also gave 6 answers!
June 20, 2014 at 5:17 am
This is a nice, straightforward question. A good way to end the week. Thanks, Andy.
June 20, 2014 at 6:14 am
Sean Pearce (6/20/2014)
erwin.oosterhoorn (6/20/2014)
There is nothing indicating if the database setting is case sensitive, our databases are. Therefore I went for different answers than the one seen as correct.Would I have been correct to say that the synonym would not have been created, the table failed to drop and the view was not created?
If not otherwise indicated in the question we should assume the server is running with default settings.
Good question.
This is a question by Andy Warren. Assumptions are dangerous 🙂
June 20, 2014 at 6:57 am
Raghavendra Mudugal (6/20/2014)
Well... the exchange of thoughts on collation is been going on from very long back, but at the end we all kind of nodded that if the mention of collation is not there then go for default "Latin1_General_CI_AI" (this is just an example and not for debate) - Or in other words drop the collation from the criteria. Sorry for your loss (i mean for points..) Now you know. 🙂
Issue with this is that there is no "default collation". Depends on the language/local of the system on which SQL Server has been installed and on the version of SQL Server.
June 20, 2014 at 7:30 am
I love "assumptions are dangerous"
Thanks to all for giving the question a try, always nice to see one go well:-)
June 20, 2014 at 7:31 am
Tricky, I failed to realize the synonym would be pointing to the view instead of the table that had been dropped.
Great question!
Be still, and know that I am God - Psalm 46:10
Viewing 15 posts - 1 through 15 (of 29 total)
You must be logged in to reply to this topic. Login to reply