Question

Concatenation operator in $SQ{L}^{\ast }$ plus _____________.

• A. &&
• B. +
• C. -
• D. ||

Answer 1

The correct option is D ||

Concatenation operator in SQL∗ plus-||.

SQL Server uses the plus sign (+) as a synonym for the ANSI SQL concatenation operator. SQL Server has the system setting CONCAT_NULL_YIELDS_NULL, which can be set to alter the behavior when NULL values are used in the concatenation of string values.

Concatenation operator in SQL:- The concatenation operator is a binary operator, whose syntax is shown in the general diagram for an SQL Expression. We can use the concatenation operator ( || ) to concatenate two expressions that evaluate to character data types or to numeric data types.