Collation, Unicode & Joins

  • Sean Pearce (7/23/2014)


    Igor Micev (7/23/2014)


    Question is good, but why would someone use a join with different collations?

    Simply to test ones knowledge of string comparison in a fun question, nothing more.

    😎 then. Thanks again.

    Igor Micev,My blog: www.igormicev.com

  • Sean Pearce (7/23/2014)Some Documentation

    Yes very good.

    Now, how about some actual documentation (from Microsoft), rather than some forum and blog posts that don't actually address the question but just assume the answer?

  • TomThomson (7/23/2014)


    Good question (but a pity about the unwanted editing).

    +1

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Toreador (7/23/2014)


    Sean Pearce (7/23/2014)Some Documentation

    Yes very good.

    Now, how about some actual documentation (from Microsoft), rather than some forum and blog posts that don't actually address the question but just assume the answer?

    I'm just having some fun, don't get cross.

    I don't think it is documented at all, but is generally well known.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • Most interesting question - thanks, Sean!

    I am just a bit skeptical that 58 percent of people got this right without running it...

    edit: typo

  • Sean Pearce (7/23/2014)


    I'm just having some fun, don't get cross.

    sorry there was meant to be a smiley in there 😛

  • Revenant (7/23/2014)


    ...

    I am just a bit skeptical that 58 percent of people got this right without running it...

    😀 Definitely I am not one of them; even though I had my assumptions right without proper basement, I still executed the code to make sure what this is going to do, and later I became more interested in actual-EP.

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

  • Great question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Nice question, thx 😀

  • Raghavendra Mudugal (7/24/2014)


    Revenant (7/23/2014)


    ...

    I am just a bit skeptical that 58 percent of people got this right without running it...

    😀 Definitely I am not one of them; even though I had my assumptions right without proper basement, I still executed the code to make sure what this is going to do, and later I became more interested in actual-EP.

    + 1 😉

Viewing 10 posts - 16 through 24 (of 24 total)

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