+ (Add) (U-SQL)
Updated: March 27, 2017
Adds two numbers, temporal types, or concatenates two strings.
| Syntax |
|---|
Add_Operator :=
expression '+' expression.
|
Semantics of Syntax Elements
Return Type
Returns the data type of the argument with the higher precedence.
Examples
- The examples can be executed in Visual Studio with the Azure Data Lake Tools plug-in.
- The scripts can be executed locally. An Azure subscription and Azure Data Lake Analytics account is not needed when executed locally.
Add with Numeric and Textual Types
@data =
SELECT * FROM
( VALUES
(38, "aString", "38")
) AS T(aNumber, aString, anotherString);
DECLARE @val int = 5;
@result =
SELECT 38 + 5 AS Int1,
aNumber + 5 AS Int2,
aNumber + @val AS Int3,
aNumber.ToString() + aString AS string1,
aString + " anotherString" AS string2,
aString + 23 AS string3, // int is implicitly converted to string
anotherString + 23 AS string4,
aNumber + "23" AS string5,
1 + 1 AS numberAndNumber,
1 + "1" AS numberAndString,
"1" + "1" AS stringAndString,
aNumber + (int?)null AS intNull,
aString + (string)null AS stringNull
FROM @data;
OUTPUT @result
TO "/ReferenceGuide/Operators/Arithmetic/Add1.txt"
USING Outputters.Csv();
Add with Temporal Types
@data =
SELECT * FROM
( VALUES
(new DateTime(2016,05,31))
) AS T(aDate);
@result =
SELECT aDate + new System.TimeSpan(1, 0, 0, 0) AS date1,
(new TimeSpan(1, 0, 0, 0) + new TimeSpan(0, 1, 0, 0)).ToString() AS date2
FROM @data;
OUTPUT @result
TO "/ReferenceGuide/Operators/Arithmetic/Add2.txt"
USING Outputters.Csv();
See Also
Community Additions
ADD
Show: