Dela via


Data Mining Extensions (DMX) Operator Reference

The Data Mining Extensions (DMX) language in Microsoft SQL Server Analysis Services supports arithmetic, assignment, comparison, logical, and unary operators. The following table lists the operators that DMX supports.

Operator

Description

+ (Add) (DMX)

An arithmetic operator that adds two numbers together.

- (Subtract) (DMX)

An arithmetic operator that subtracts one number from another number.

* (Multiply) (DMX)

An arithmetic operator that multiplies one number by another number.

/ (Divide) (DMX)

An arithmetic operator that divides one number by another number.

< (Less Than) (DMX)

A comparison operator. For arguments that evaluate to non-null values, returns TRUE if the value of the argument on the left is less than the value of the argument on the right; returns FALSE otherwise. If either argument or both arguments evaluate to a null value, the operator returns a null value.

> (Greater Than) (DMX)

A comparison operator. For arguments that evaluate to non-null values, returns TRUE if the value of the argument on the left is greater than the value of the argument on the right; returns FALSE otherwise. If either argument or both arguments evaluate to a null value, the operator returns a null value.

= (Equal To) (DMX)

A comparison operator. For arguments that evaluate to non-null values, returns TRUE if the value of the argument on the left is equal to the value of the argument on the right; returns FALSE otherwise. If either argument or both arguments evaluate to a null value, the operator returns a null value.

<> (Not Equal To) (DMX)

A comparison operator. For arguments that evaluate to non-null values, returns TRUE if the value of the argument on the left is not equal to the value of the argument on the right; returns FALSE otherwise. If either argument or both arguments evaluate to a null value, the operator returns a null value.

<= (Less Than or Equal To) (DMX)

A comparison operator. For arguments that evaluate to non-null values, returns TRUE if the value of the argument on the left is less than or equal to the value of the argument on the right; returns FALSE otherwise. If either argument or both arguments evaluate to a null value, the operator returns a null value.

>= (Greater Than or Equal To) (DMX)

A comparison operator. For arguments that evaluate to non-null values, returns TRUE if the value of the argument on the left is greater than or equal to the value of the argument on the right; returns FALSE otherwise. If either argument or both arguments evaluate to a null value, the operator returns a null value.

AND (DMX)

A logical operator that performs a conjunction on two numeric expressions.

NOT (DMX)

A logical operator that performs a negation on a numeric expression.

OR (DMX)

A logical operator that performs a disjunction on two numeric expressions.

+ (Positive) (DMX)

A unary operator that returns the positive value of a numeric expression.

- (Negative) (DMX)

A unary operator that returns the negative value of a numeric expression.

// (Comment) (DMX)

Indicates a text string that Analysis Services should not execute. You can nest comments within a DMX statement, include them at the end of a line of code, or insert them on a separate line.

-- (Comment) (DMX)

Indicates a text string that Analysis Services should not execute. You can nest comments within a DMX statement, include them at the end of a line of code, or insert them on a separate line.

/*...*/ (Comment) (DMX)

Indicates a text string that Analysis Services should not execute. You can nest comments within a DMX statement, include them at the end of a line of code, or insert them on a separate line.