Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

* (Multiply) (SQL Server Compact)

Multiplies two expressions.

expression * expression


Any valid expression in Microsoft SQL Server Compact 3.5 of any of the data types of the numeric data type category, except the datetime data type.

Returns the data type of the argument with the higher precedence.

The following example determines the cost of a customer order by multiplying the quantity ordered by the unit price from the Order Details table.

SELECT UnitPrice * Quantity AS "Total Cost" FROM "Order Details" WHERE ProductID = '11' AND OrderID = '10248'

This is the result set:

Total Cost
© 2016 Microsoft