April 13, 2009 at 8:25 pm
Comments posted to this topic are about the item T-SQL Operators
April 13, 2009 at 8:30 pm
Well I got it wrong because I was not familiar with the except operator. But is MDX considered T-SQL?
April 14, 2009 at 1:10 am
Bah?
April 14, 2009 at 2:33 am
When MDX is considered part of mainstream t-sql language construct then fine. Otherwise it should have being labelled MDX as the topic.
------
Robert
April 14, 2009 at 2:57 am
'-' sign used for the purpose of 'Except' in Database Engine Query window gives error...
April 14, 2009 at 2:59 am
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)...
April 14, 2009 at 5:27 am
MDX <> TSQL. Except is not a correct answer.
April 14, 2009 at 5:42 am
I think, "-" Except supports SQL 2005 and above versions.
April 14, 2009 at 6:02 am
I agree - BAH! MDX is not T-SQL. I am going to tell my mummy!
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);April 14, 2009 at 6:03 am
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]
April 14, 2009 at 6:42 am
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
April 14, 2009 at 6:49 am
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.
April 14, 2009 at 7:29 am
'-' 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."
April 14, 2009 at 7:50 am
MDX is an entirely separate language from SQL or the T-SQL variant. The author is the one that's wrong.
April 14, 2009 at 8:02 am
I think you need to show us where the '-' as an except operator exists in the Transact SQL Reference.
Viewing 15 posts - 1 through 15 (of 32 total)
You must be logged in to reply to this topic. Login to reply