Adds two numbers. This addition arithmetic operator also can add a number, in days, to a date.
expression + expression
- Is any valid expression in Microsoft® SQL Server™ 2000 Windows® CE Edition (SQL Server CE) of any of the data types in the numeric category, except the bit data type.
Returns the data type of the argument with the higher precedence.
The following example computes the total number of customers when the goal of adding 50 new customers is achieved. This query assumes that there are 90 customers listed in the Customers table in the Northwind database.
SELECT COUNT(CustomerID) + 50 AS "Target Total" FROM Customers
This is the result set:
Target Total ------------ 140