Export (0) Print
Expand All
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

* (Multiply) (SQL Server Compact)

Multiplies two expressions.


expression * expression
expression

Any valid expression in Microsoft SQL Server Compact 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
----------
168
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.