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
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