T-SQL Operators

Question

Post reply

T-SQL Operators

VM-723206

SSCrazy

Points: 2964
More actions
April 13, 2009 at 8:25 pm

#202923

Comments posted to this topic are about the item T-SQL Operators
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

Kevin SSCarpal Tunnel Points: 4962 More actions · Answer 1

Well I got it wrong because I was not familiar with the except operator. But is MDX considered T-SQL?

Carlo Romagnano SSC-Insane Points: 22755 More actions · Answer 2

Carlo Romagnano

SSC-Insane

Points: 22755

April 14, 2009 at 1:10 am

#977050

Bah?

rcavill Default port Points: 1482 More actions · Answer 3

When MDX is considered part of mainstream t-sql language construct then fine. Otherwise it should have being labelled MDX as the topic.

------

Robert

Atif-ullah Sheikh SSChampion Points: 12495 More actions · Answer 4

'-' sign used for the purpose of 'Except' in Database Engine Query window gives error...

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.
You can check my BLOG [font="Arial Black"]here[/font][/url][/right]

liam.stirling Say Hey Kid Points: 689 More actions · Answer 5

So I'm not the only one that thinks that MDX is not T-SQL. An instructor on a course I attended said, "think of MDX as T-SQL for cubes" (i.e. although it serves the same function, it is not the same thing)...

Lisa Phillip SSCrazy Points: 2991 More actions · Answer 6

Lisa Phillip

SSCrazy

Points: 2991

April 14, 2009 at 5:27 am

#977130

MDX <> TSQL. Except is not a correct answer.

Kishore.P SSCrazy Eights Points: 8147 More actions · Answer 7

I think, "-" Except supports SQL 2005 and above versions.

mister.magoo SSC-Forever Points: 47174 More actions · Answer 8

I agree - BAH! MDX is not T-SQL. I am going to tell my mummy!

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

Christopher Stobbs SSC-Insane Points: 21098 More actions · Answer 9

I don't think MDX is t-sql either

----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley

:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]

SQL-4-Life

webrunner SSC-Dedicated Points: 31991 More actions · Answer 10

I didn't even know the MDX usage, so I probably would've gotten this wrong anyway. But another comment I have is about the ambiguity of '-' as it relates to being "for" single-line comments. A single-line comment needs two '-' but each one is needed "for" the comment. I guess ambiguity is sometimes part of the challenge, but in this case it was a little confusing.

- webrunner

(it's not T-SQL, but '-' can also be used for signatures )

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

OCTom SSChampion Points: 11785 More actions · Answer 11

Microsoft lists MDX functionality within the T-SQL documentation. If you research the topic on the internet, most authors define it as a separate language. In any case, I learned something new today and that's always a good thing.

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 12

'-' is also a part of 'wildcard' characters ...

http://msdn.microsoft.com/en-us/library/ms179884(SQL.90).aspx

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

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

MDX is an entirely separate language from SQL or the T-SQL variant. The author is the one that's wrong.

Cliff Jones SSChampion Points: 10547 More actions · Answer 14

I think you need to show us where the '-' as an except operator exists in the Transact SQL Reference.

T-SQL Operators

Cookies on SQLServerCentral