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.
That's all.thank you for reading.