XML Path in SQL Server

Here, we use SYSUSER table in SQL Server to see the all NAME in a single row…

SELECT name FROM sysusers

SELECT name FROM sysusers FOR XML PATH ('')

SELECT ',' + name FROM sysusers FOR XML PATH ('')

SELECT STUFF((SELECT ',' + name FROM sysusers FOR XML PATH ('')),1,1,'')

SELECT STUFF((SELECT ',' + QUOTENAME(name) FROM sysusers FOR XML PATH ('')),1,1,'')

SELECT STUFF(( SELECT ''','''+ QUOTENAME(name) FROM sysusers FOR XML PATH ('')),1,2,'')

Results as follws by SQL query…

SELECT STUFF ( ( SELECT name + ' ,' FROM sysusers

                         FOR XML PATH('')

                        ),1,0,''

                  )'USER_NAME'

SELECT REPLACE(

            REPLACE(

                  STUFF(

                        (SELECT name + ' ,' FROM sysusers

                         FOR XML PATH('')

                        ),1,0,''

                          ),'$$',','

                        ),'$',''

                     ) 'USER_NAME'