反转TSQL中单词的顺序

DECLARE @text NVARCHAR(MAX) = 'Hello World'

SELECT STRING_AGG(value, ' ') 
FROM STRING_SPLIT(@text, ' ')

DECLARE @text NVARCHAR(MAX) = 'Hello World'

SELECT SUBSTRING(
         @text,
         CHARINDEX(' ', @text) + 1,
         LEN(@text) - CHARINDEX(' ', @text) - CHARINDEX(' ', REVERSE(@text)) + 1
       ) + ' ' + SUBSTRING(
         @text,
         1,
         CHARINDEX(' ', @text) - 1
       )

DECLARE @text NVARCHAR(MAX) = 'Hello World'

SELECT STUFF(
         (SELECT ' ' + value
          FROM OPENXML(
                   CAST('<r><![CDATA[' + REPLACE(@text, ' ', ']]></r><r><![CDATA[') + ']]></r>' AS XML)
                 )
                 WITH (value NVARCHAR(MAX) '.')
          ORDER BY '.', value
          FOR XML PATH('')
         ), 1, 1, '')