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
Form Based Authentication in MOSS2010 Against SQL Server Database
SQL Server 2008 Recovery Models
Does that mean the string concatenation operator '+' is a new feature of SQL Server 2008 R2? Was this not possible in earlier versions? I am sure I have done this many times even in previous versions. Also you mentioned scope resolution operator. There are no further details and the information is almost similar to what MSDN page shows @ http://msdn.microsoft.com/en-us/library/dd206995.aspx. And verify your facts about this too. This operator is available in SQL 2008 (yes non R2 version) too.