sql server for xml行专列几种写法

STUFF('abcdef',1,1,'') 从第一个位置删除第一个字符

     SELECT STUFF(
             
            (
            SELECT '，'+CAST(WORK_ORDER AS VARCHAR(10))FROM dbo.WORKORDER FOR XML PATH('')
            )  ,1,1,'')

             SELECT STUFF(
             
            (
            SELECT '，'+CAST(WORK_ORDER AS VARCHAR(10))FROM dbo.WORKORDER FOR XML PATH('')
            , TYPE).value('.', 'NVARCHAR(MAX)')  ,1,1,'A')

                 SELECT STUFF(
             
            (
            SELECT '，'+CAST(WORK_ORDER AS VARCHAR(10))FROM dbo.WORKORDER  FOR XML PATH('')
            )  ,1,1,'A')

DECLARE @STR VARCHAR(100)=''
            SELECT  @STR=(SELECT '，'+CAST(WORK_ORDER AS VARCHAR(10))FROM dbo.WORKORDER  FOR XML PATH('')
            
            )
            PRINT @STR

写法都差不多，都能行专列 xml变字符串需要外面套一个()