String Concatenation and Scope Resolution Operator in SQL Server 2008 R2

Target Audience: Beginners

SQL Server 2008 R2 comes with String Concatenation Operator.

String Concatenation operator is denoted by symbol plus '+'.


Output we will get,


String concatenation operator can concatenate string with real time data of any type also.


In above query , firstName and lastName column is being concatenated using string concatenation operator of SQL Server 2008 R2. In above query we are also concatenating HireDate . Since HireDate is of type DateTime , we need to convert that first before concatenating.


SQL Server 2008 R2 comes with Scope Resolution Operator.

Scope Resolution operator is denoted by symbol '::'

It is used to access static members of compound data type.


In above query hierarchyId is a compound data type. And we are accessing static function GetRoot() of this type.