Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

T-SQL Operators Expand / Collapse
Author
Message
Posted Monday, April 13, 2009 8:25 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Saturday, April 06, 2013 12:20 AM
Points: 649, Visits: 263
Comments posted to this topic are about the item T-SQL Operators
Post #696278
Posted Monday, April 13, 2009 8:30 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:52 AM
Points: 2,796, Visits: 1,125
Well I got it wrong because I was not familiar with the except operator. But is MDX considered T-SQL?


Post #696279
Posted Tuesday, April 14, 2009 1:10 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:51 AM
Points: 1,972, Visits: 1,821
Bah?
Post #696335
Posted Tuesday, April 14, 2009 2:33 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, April 01, 2013 11:51 PM
Points: 292, Visits: 794
When MDX is considered part of mainstream t-sql language construct then fine. Otherwise it should have being labelled MDX as the topic.

------
Robert



Post #696363
Posted Tuesday, April 14, 2009 2:57 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, March 14, 2013 4:15 AM
Points: 3,240, Visits: 4,960
'-' 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 here

Post #696370
Posted Tuesday, April 14, 2009 2:59 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, January 08, 2013 7:08 AM
Points: 469, Visits: 124
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)...
Post #696371
Posted Tuesday, April 14, 2009 5:27 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, February 14, 2013 7:48 AM
Points: 2,321, Visits: 135
MDX <> TSQL. Except is not a correct answer.
Post #696436
Posted Tuesday, April 14, 2009 5:42 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, November 26, 2012 3:25 AM
Points: 1,389, Visits: 596
I think, "-" Except supports SQL 2005 and above versions.



Post #696442
Posted Tuesday, April 14, 2009 6:02 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:14 AM
Points: 1,294, Visits: 3,871
I agree - BAH! MDX is not T-SQL. I am going to tell my mummy!

MM




Post #696451
Posted Tuesday, April 14, 2009 6:03 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, February 24, 2010 4:10 AM
Points: 1,553, Visits: 2,232
I don't think MDX is t-sql either

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


Posting Best Practices
Numbers / Tally Tables

SQL-4-Life
Post #696452
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse