Collation, Unicode & Joins

  • Igor Micev

    SSC-Dedicated

    Points: 33109

    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

  • Toreador

    SSChampion

    Points: 11256

    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?

  • SQLRNNR

    SSC Guru

    Points: 281243

    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

  • Sean Pearce

    SSCoach

    Points: 15750

    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]

  • Revenant

    SSC-Forever

    Points: 42467

    Most interesting question - thanks, Sean!

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

    edit: typo

  • Toreador

    SSChampion

    Points: 11256

    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 😛

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    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.

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Great question, thanks.

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

  • Hany Helmy

    SSChampion

    Points: 13488

    Nice question, thx 😀

  • Hany Helmy

    SSChampion

    Points: 13488

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

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