wiz-icon
MyQuestionIcon
MyQuestionIcon
1
You visited us 1 times! Enjoying our articles? Unlock Full Access!
Question

Concatenation operator in SQL plus _____________.

A
&&
No worries! We‘ve got your back. Try BYJU‘S free classes today!
B
+
No worries! We‘ve got your back. Try BYJU‘S free classes today!
C
-
No worries! We‘ve got your back. Try BYJU‘S free classes today!
D
||
Right on! Give the BNAT exam to get a 100% scholarship for BYJUS courses
Open in App
Solution

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.



flag
Suggest Corrections
thumbs-up
0
Join BYJU'S Learning Program
similar_icon
Related Videos
thumbnail
lock
Closure Property
MATHEMATICS
Watch in App
Join BYJU'S Learning Program
CrossIcon