is there any difference between != and <>

Question

is there any difference between != and <>

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

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: 1003867 More actions · Answer 2

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.

Change is inevitable... Change for the better is not.

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

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 3

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?