is there any difference between != and <>

  • Gail Shaw

    SSC Guru

    Points: 1004446

    Matt Miller (11/15/2007)


    Gail - as to your test - I will try to dig out and use the XML data() trick, we'll let Jeff come up with the "pure" T-SQL trick, and you can handle the CLR?

    I can try. I'll hopefully find 5 min today. I can't promise it will be the best performing CLR out there. I'm still much a novice with C

    Sorry, things are just rather hectic right now.

    Edit: i see Matt beat me to it. 😀

    I thought that was how the XML trick worked. There's some very nifty tricks that can be dome with the new XML features. I particuarly like FOR XML TYPE in a subquery.

    Jeff, I'm going to steal that concat function from you. I normally resrt to temp tables and cursors. :pinch:

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Jeff Moden

    SSC Guru

    Points: 994667

    Jeff, I'm going to steal that concat function from you. I normally resrt to temp tables and cursors

    Absolutely no problem, Gail... that's one of the highest forms of compliments I could ever ask for.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems
    Create a Tally Function (fnTally)

  • Matt Miller (4)

    SSC Guru

    Points: 124184

    GilaMonster (11/15/2007)


    Matt Miller (11/15/2007)


    Gail - as to your test - I will try to dig out and use the XML data() trick, we'll let Jeff come up with the "pure" T-SQL trick, and you can handle the CLR?

    I can try. I'll hopefully find 5 min today. I can't promise it will be the best performing CLR out there. I'm still much a novice with C

    Sorry, things are just rather hectic right now.

    Edit: i see Matt beat me to it. 😀

    I thought that was how the XML trick worked. There's some very nifty tricks that can be dome with the new XML features. I particuarly like FOR XML TYPE in a subquery.

    Jeff, I'm going to steal that concat function from you. I normally resrt to temp tables and cursors. :pinch:

    Sorry there Gail - I was hoping not to steal your thunder (thought you might have another idea on how to tackle). I just came across the old CLR UDA sample, and , well - it seemed appropriate....

    Still - all of these seem to be pretty performant - so I'm thinking they all make the scrapbook...

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Viewing 3 posts - 61 through 63 (of 63 total)

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