SQL Server for XML Path learning

Recently saw too many people ask this kind of question oneself also do not know very much to learn on the net study oneself test

CREATE TABLE test0621 (
ID INT,
NAME NVARCHAR (max)
)

INSERT test0621 VALUES (1, ' AA '), (1, ' BB '), (1, ' CC ')
INSERT test0621 VALUES (2, ' Monday '), (2, ' Tuesday '), (2, ' Wednesday ')

DROP TABLE test0621

SELECT * from test0621

SELECT * from test0621 for XML PATH (")--Delete the row node

SELECT * from test0621 for XML PATH (' xx ')--Change row node to XX

SELECT name+ ', ' from test0621 for XML PATH (')--Custom display

SELECT ID, (
SELECT name+ ', ' from test0621 WHERE id = a.id for XML PATH (')--correlation ID
) as NAME
From test0621 A
GROUP BY a.ID--No group by is displayed as more than one

SQL Server for XML Path learning