T-SQL Operators

Question

Post reply

T-SQL Operators

Viewing 15 posts - 16 through 30 (of 32 total)

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

Noel McKinney Hall of Fame Points: 3452 More actions · Answer 1

Two days in a row of QOD strangeness. MDX is now part of TSQL?

If I write a CLR function in C# and call it in a TSQL statement, does that mean C# is now part of TSQL?

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

I have to agree. I don't consider MDX to be a part of T-SQL. T-SQL is used to query MS SQL Server databases. Last I knew, MDX was used to query Analysis Services Cubes.

OzYbOi d(-_-)b SSCarpal Tunnel Points: 4054 More actions · Answer 3

Wow - Guess I'm not the only one who was thrown for a loop by the answer to this question.

I have to agree that MDX is separate from TSQL. If they are the same, why does BOL branch at the SQL Server Language Reference level (choices are TSQL, MDX & DMX)? I noticed this when I looked at the example links provided in the explanation...

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 4

I guess not enough people complained about the answer to this question.

mverma4you Ten Centuries Points: 1013 More actions · Answer 5

How can you consider MDX as TSQL. MDX and TSQL is totally different.

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 6

I agree with the previous comments.

I think everyone of us has made the error of looking something up in BOL but missing the "MDX" or (more common for me) "SQL Server Compact Edition" header above the page. So I understand how this error could have slipped into the question. But I do think that it has to be corrected.

(Even though it will lose me a point - I accidentally clicked the wrong answer and noticed only after submitting my answer, so I was quite surprised that I did actually receive a point!)

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Lisa Phillip SSCrazy Points: 2991 More actions · Answer 7

MDX is not TSQL. My answer was correct since the topic was labeled T-SQL Operators.

ppcx Ten Centuries Points: 1359 More actions · Answer 8

http://msdn.microsoft.com/en-us/library/ms188055(SQL.90).aspx ==> Except and Intersect have no mention of "-"

http://msdn.microsoft.com/en-us/library/ms190276(SQL.90).aspx ==> Operator order doesn't list except

http://msdn.microsoft.com/en-us/library/ms189826(SQL.90).aspx ==> Transact-SQL Reference lists:

- (Negative) (Transact-SQL)

- (Subtract) (Transact-SQL)

But it does not list a "-" equaling EXCEPT

Toreador SSChampion Points: 11365 More actions · Answer 9

Lynn Pettis (4/14/2009)
I guess not enough people complained about the answer to this question.

I guess I'd better complain too then 😉

MDX != TSQL

Ken Garrett SSC Eights! Points: 924 More actions · Answer 10

I would like to pile on as well and claim that MDX is not equivalent to T-SQL. I found the question to misleading by not stating that a mix of MDX and T-SQL was being used as the subject area.

Ken

OzYbOi d(-_-)b SSCarpal Tunnel Points: 4054 More actions · Answer 11

OzYbOi d(-_-)b

SSCarpal Tunnel

Points: 4054

April 17, 2009 at 7:20 am

#979642

Maybe this should be the next QotD:

Is MDX TSQL?

😛

Barry McConnell SSChasing Mays Points: 660 More actions · Answer 12

OzYbOi d(-_-)b (4/17/2009)
Maybe this should be the next QotD:
Is MDX TSQL?
😛

And the answers would be No, Hell No, Are You Kidding, and Turn In Your Geek Card.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 13

So Steve, are we going to allow this one to stand? I have yet to read a post in support of the "correct" answer yet.

Lisa Phillip SSCrazy Points: 2991 More actions · Answer 14

I think recognizing that MDX is NOT TSQL should give us our points.

StarNamer SSCrazy Eights Points: 8746 More actions · Answer 15

I clicked this as a T-SQL question I'd overlooked. I've never used MDX yet and would join the view that MDX is not T-SQL, so the 'except' operator is not allowed!

Derek