1. Query to concatenate two column
SELECT (CAST(Name1 AS varchar(50))+’ ‘+CAST(Name2 AS varchar(50))) AS AliasName FROM Table

Thank you for reading this post, don't forget to subscribe!

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