How to combine two columns in SQL SERVER

How to combine two columns in SQL SERVER?

Before going to this query please go through Download adventureworks database for sql server 2008 r2

  SELECT top 10 cast(DAY(HireDate) as varchar) + ' '+ 
         CONVERT(CHAR(4), HireDate, 100) as MonthDate
FROM [AdventureWorks2008R2].[HumanResources].[Employee]


Output:



Share this post :

Post a Comment

Please give your valuable feedback on this post. You can submit any ASP.NET article here. We will post that article in this website by your name.

 
Support : Ranga Rajesh Kumar
Copyright © 2012. ASP.NET Examples - All Rights Reserved
Site Designed by Ranga Rajesh Kumar