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 '+'.

string1.gif

Output we will get,

string2.gif

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

string3.gif

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.

string4.gif

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.

string5.gif

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

Output

string6.gif

Up Next
    Ebook Download
    View all
    Learn
    View all