Export (0) Print
Expand All
Expand Minimize

* (Multiply) (SQL Server Compact Edition)

Multiplies two expressions.


expression * expression

expression

Any valid expression in Microsoft SQL Server 2005 Compact Edition 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
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft