Synonym

  • Hardy21

    SSCrazy Eights

    Points: 9708

    Comments posted to this topic are about the item Synonym

    Thanks

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    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

  • danielfountain

    SSCarpal Tunnel

    Points: 4229

    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 🙂

  • SqlMel

    SSCrazy

    Points: 2891

    Thanks for the question.

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

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

  • Ed Wagner

    SSC Guru

    Points: 286982

    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.

  • Thomas Abraham

    SSChampion

    Points: 10761

    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

  • Hardy21

    SSCrazy Eights

    Points: 9708

    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

  • stephen.long.1

    SSCrazy

    Points: 2577

    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!

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    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 10 (of 10 total)

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