Reader Level:
Articles

String Concatenation and Scope Resolution Operator in SQL Server 2008 R2

By Dhananjay Kumar on March 03, 2011
Here you will learn String Concatenation and Scope Resolution Operator in SQL Server 2008 R2.
  • 0
  • 0
  • 6902

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

COMMENT USING

Trending up