Compartir a través de

Numeric Expressions (M to SQL Mapping)

  • Artículo

[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]

Numeric values have a small number of operators that can act upon them. These operators generally translate verbatim to SQL.

Operator “M” Example SQL Example

*, /, +, -, %

 
A op B
 
A op B

+, - (unary)

 
									op A
 
									op A

<, >, >=, <=

 
A op B
 
A op B

==

A == B

A = B

!=

A != B

A <> B

Exceptions

Integer8/16/32/64 and Unsigned8/16/32 divide. These translate to “convert(decimal(x,6), A) / convert(decimal(x,6), B)” (where x is replaced by the smallest possible decimal value that can represent the entire range of values for the concrete integer type).

Single and double modulo operators are unsupported.