• Comments posted to this topic are about the item Synonym


  • thank you for post, simply nice and easy and yet it still fires the curiosity of knowing the answer selected is the correct one. 🙂

    ww; Raghu
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • This was removed by the editor as SPAM

  • Thank you for the question.

    I always find the questions that i straight away feel i know the answer a little disconcerting. I always feel i have missed something 🙂

  • Thanks for the question.

    I came across this fact just yesterday so I had it fresh in my mind 😀

    Mel. 😎

  • Yeah, the simple ones are the ones you have to stop and ask yourself what you're missing. I was right, but I still looked it up to make sure a new command wasn't slipped in I didn't know about. Thanks for the question.

  • Thanks for question! Easy but still had to think about it. Please post another QOTD.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • Thomas Abraham (8/1/2014)

    Thanks for question! Easy but still had to think about it. Please post another QOTD.

    Sure, on the way 😛


  • Thanks for the question. I thought I knew the answer upon reading the question (based upon reading BOL, not personal experience), but I wasn't sure. Since the question referenced SQL 2012, I thought that ALTER SYNONYM might have been added with that version (or with SQL 2014, in which case the question would have been designed to "trip up" someone into thinking that it was available in SQL 2012), but it's not available in SQL 2014, either.

    This makes me wonder what else is in SQL that has CREATE and DROP, but not ALTER functionality. :unsure: Hey, that might make an excellent multiple-choice QOTD!

  • Nice question, thanks.

    Need an answer? No, you need a question
    My blog at
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 10 posts - 1 through 9 (of 9 total)

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