T-SQL Operators

  • Comments posted to this topic are about the item T-SQL Operators

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

  • Bah?

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

    ------

    Robert

  • '-' 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]

  • 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)...

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

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

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

    MM



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

  • 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]

  • 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
  • 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

  • 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.

  • '-' 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."

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

  • 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