Post reply

Synonym

  • July 31, 2014 at 11:51 pm

    #297220

    Comments posted to this topic are about the item Synonym

    Thanks

  • August 1, 2014 at 1:23 am

    #1734351

    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.

  • August 1, 2014 at 2:22 am

    This was removed by the editor as SPAM

  • August 1, 2014 at 3:57 am

    #1734384

    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 🙂

  • August 1, 2014 at 5:15 am

    #1734395

    Thanks for the question.

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

    ---------------
    Mel. 😎

  • August 1, 2014 at 5:44 am

    #1734400

    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.

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • August 1, 2014 at 7:34 am

    #1734431

    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

  • August 1, 2014 at 7:41 am

    #1734435

    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

  • August 1, 2014 at 7:51 am

    #1734442

    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!

  • August 1, 2014 at 10:27 am

    #1734499

    Nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    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