* (Multiply) (Transact-SQL)

* (Multiply) (Transact-SQL)

 

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2008) yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

Multiplies two expressions (an arithmetic multiplication operator).

Topic link icon Transact-SQL Syntax Conventions


expression * expression
-- Azure SQL Data Warehouse and Parallel Data Warehouse
      expression 
      *
      expression

expression

Is any valid expression of any one of the data types of the numeric data type category, except the datetime and smalldatetime data types.

Returns the data type of the argument with the higher precedence. For more information, see Data Type Precedence (Transact-SQL).

The following example retrieves the product identification number, name, the list price and the new list price of all the mountain bicycles in the Product table. The new list price is calculated by using the * arithmetic operator to multiply ListPrice by 1.15.

-- Uses AdventureWorks

SELECT ProductID, Name, ListPrice, ListPrice * 1.15 AS NewPrice
FROM Production.Product
WHERE Name LIKE 'Mountain-%'
ORDER BY ProductID ASC;
GO

The following example retrieves the first and last name of employees in the dimEmployee table, and calculates the pay for VacationHours for each..

-- Uses AdventureWorks

SELECT FirstName, LastName, BaseRate * VacationHours AS VacationPay
FROM DimEmployee
ORDER BY lastName ASC;

Community Additions

ADD
Show:
© 2016 Microsoft