Target Audience: Beginners

SQL Server 2008 R2 comes with String Concatenation Operator.

String Concatenation operator is denoted by symbol plus ‘+’.

clip_image002

Output we will get,

clip_image003

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

clip_image005

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.

clip_image007

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.

clip_image009

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

Output

clip_image010

Advertisements

One thought on “String Concatenation and Scope Resolution Operator in SQL Server 2008 R2

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s