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 ‘+’.

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

Published by

Dhananjay Kumar

Dhananjay Kumar is Developer Evangelist for Infragistics. He is a 8 times Microsoft MVP and well respected Developer Advocate in India.He is the author of 900+ Blog Posts, and can often be found speaking around India at conferences and hosting free workshops for programmers across the country. So far, he has hosted 60 free workshops on various topics like JavaScript, Angular, WCF, ASP.NET MVC, C#, Azure etc. Follow him on twitter @debug_mode for all the updates about his blog posts and workshops. You can send him email at debugmode [at] outlook [dot] com

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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s