Target Audience: Beginners
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
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
Dhananjay kumar is 6 times Microsoft MVP, 7 times C# Corner MVP. He works as Developer Evangelist for Infragistics in India. He is known for mentoring teams on various technologies.
C# Corner. All contents are copyright of their authors.