Concatenate row data into a single data in SQL Server

Venkatesan Jayakantham

How to concatenate the row data into a single data?

 [CODE]
DECLARE @NAME VARCHAR(100) =''
SELECT @NAME= @NAME + ',' + 
NAME   FROM VENKAT_NAME_TABLE
SELECT 
SUBSTRING(@NAME,1,LEN(@NAME))
[/CODE]

1 Comment

Join the conversation! Your thoughts help the community grow.

Sandeep Singh Shekhawat13y ago
Why are you using SELECT SUBSTRING(@NAME,1,LEN(@NAME)) ? While it gives same output as SELECT @NAME