String Concatenation and Scope Resolution Operator in SQL Server 2008

No.of Views	:	983
Bookmarked	:	0 times
Downloads	:
Votes	:	0

By Dhananjay Kumar On 27 Mar 2011 07:03:56

Tag : Sql Servers , Database Administrator

Skill Level: Beginner

In this article,i will show how to String Concatenation and Scope Resolution Operator in SQL Server 2008.

Images in this article missing? We recently lost them in a site migration. We're working to restore these as you read this. Should you need an image in an emergency, please contact us at info@codegain.com

Introduction

In this article,i will show how to String Concatenation and Scope Resolution Operator in SQL Server 2008.

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.

Output

That's all.thank you for reading.

About Author

Dhananjay Kumar

Occupation	-	Software Engineer
Company	-	Infosys Technolgies,Pune
Member Type	-	Gold
Location	-	India
Joined date	-	20 Jul 2009
Home Page	-	http://dhananjaykumar.net/
Blog Page	-	http://dhananjaykumar.net/

Dhananjay Kumar is Microsoft MVP on connected system. He blogs at http://dhananjaykumar.net/ . You can follow him http://twitter.com/debugmode_/ and reach him at dhananjay.25july@gmail.com


Other popularSectionarticles
What is Advantages/Disadvantages using GUID over Integer as primary key In this article, I would list out Advantages and Disadvantages using GUID over Integer as primary key in Sql server. Because when you are creating table, you have to decide a correct data type for the primary key for better database performance. Published Date : 05/Dec/2010 Avoiding Global temporary table problems between databases Avoiding Global temporary table problems between databases Published Date : 16/Feb/2010 SQL Performance Good Practices and Tips This article gives simple practical guidelines which will help a developer to design good performance, high quality SQL databases. Published Date : 23/May/2010 Use of Begin, Commit, Rollback Transactions in SQL Server The SQL Server provides very useful feature which is Begin, Commit, Rollback Transaction. Published Date : 31/May/2010 SQL Script for take backup of Database in sql server In sql server there are 2 built-in stored procedures for drop the already existing backup device and create the new device in the user defined path. Published Date : 08/May/2010

Comments

There is no comments for this articles.