Post reply

Schema & Renaming Fun

  • March 12, 2014 at 9:11 am

    #1696440

    Hah hah hah! Thanks, Andy!

  • March 12, 2014 at 11:50 am

    #1696498

    Interesting question, thanks!

    Igor Micev,My blog: www.igormicev.com

  • March 12, 2014 at 5:15 pm

    #1696583

    Thanks, it was an easy one. 😀

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • March 13, 2014 at 8:48 am

    #1696825

    It was funny , even though the final output was not.funny :w00t:

  • March 14, 2014 at 12:29 pm

    #1697245

    Amusing question. Since we regularly see statements that the questions, unless they state otherwise, are based on a default US install of a version currently in full support the case insensitivity isn't an issue. So it seems a good question to me.

    The explanation is a bit confusing though, referring to the first and second renames but not to the third (which is the only one which actually changes anything).

    I find it a bit disturbing that more than half the answers are wrong. This is all very basic and trivial T-SQL syntax stuff, nothing in the slightest bit off except perhaps a table name (as opposed to a tablename qualified by a schema name) containing a dot which might seem odd to some people. However, I don't get all the answers right myself, so maybe I shouldn't expect too much accuracy in the attempted answers.

    Tom

  • March 14, 2014 at 2:15 pm

    #1697307

    nice and interesting QOTD..

    thanks Andy.

  • March 16, 2014 at 12:33 am

    #1697460

    crussell-931424 (3/13/2014)

    Definitely not not funny.

    Definitely.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • March 18, 2014 at 12:50 am

    #1697869

    good question, thanks.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

Viewing 8 posts - 16 through 22 (of 22 total)

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