Poecilonym Madness!

  • Comments posted to this topic are about the item Poecilonym Madness!

  • 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
    🙂

  • Thanks for the question

    I've missed something about synonym. I need to review the subject

  • Interesting question, thank you Andy.

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

  • 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?

  • 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.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • This was removed by the editor as SPAM

  • 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.

  • 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.

  • 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!

  • This is a nice, straightforward question. A good way to end the week. Thanks, Andy.

  • 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 🙂

  • 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.

  • I love "assumptions are dangerous"

    Thanks to all for giving the question a try, always nice to see one go well:-)

  • Tricky, I failed to realize the synonym would be pointing to the view instead of the table that had been dropped.

    Great question!


    [font="Tahoma"]Personal blog relating fishing to database administration:[/font]

    [font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

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

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