Query to concatenate two column values in SQL Server

I will explain how to write a query to concatenate two columns of data to single column in datatable using SQL server.

Two Syntax:

Syntax 1:

SELECT (CONVERT(varchar(50),Column1)+’ ‘+CONVERT(varchar(50),Column2)) AS ConcatnatedColumnFROM TableName

Syntax 2:

SELECT (CAST(ColumnName1 AS varchar(50))+’ ‘+CAST(ColumnName2 AS varchar(50))) ASConcatnatedColumn FROM TABLENAME