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