Poecilonym Madness!

  • Andy Warren

    SSC Guru

    Points: 119676

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

  • rhythmk

    SSCertifiable

    Points: 7162

    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
    🙂

  • domenico.delbrocco

    Mr or Mrs. 500

    Points: 587

    Thanks for the question

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

  • free_mascot

    One Orange Chip

    Points: 27168

    Interesting question, thank you Andy.

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

  • erwin oosterhoorn

    SSCrazy

    Points: 2111

    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?

  • Sean Pearce

    SSCoach

    Points: 15750

    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

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    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.

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    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.

  • Toreador

    SSChampion

    Points: 11248

    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!

  • Ed Wagner

    SSC Guru

    Points: 286975

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

  • Gazareth

    One Orange Chip

    Points: 27737

    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 🙂

  • Mighty

    SSCrazy Eights

    Points: 8597

    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.

  • Andy Warren

    SSC Guru

    Points: 119676

    I love "assumptions are dangerous"

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

  • david.gugg

    SSCertifiable

    Points: 5692

    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 30 total)

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