1. Query to concatenate two column
SELECT (CAST(Name1 AS varchar(50))+’ ‘+CAST(Name2 AS varchar(50))) AS AliasName FROM Table
Ex:
SELECT (CAST(FirstName AS varchar(50))+’ ‘+CAST(LastName AS varchar(50))) AS Name FROM Table
1. Query to concatenate two row
DECLARE @text NVARCHAR(MAX)
SELECT @text= COALESCE(@text+ ‘,’, ”) + Name FROM Table //Name:Field Name
SELECT UserNames = @name