Name XML result column of TSQL "for xml explicit"?

Answer 1

No, there is not, as far as I know. SQL Server Management Studio will autogenerate such a name for your XML.

You might be able to assign your output to an XML variable first and then select that to get a "nice" column name:

DECLARE @XmlResult XML

SELECT @XmlResult = ......
  FROM .......


SELECT @XmlResult

but other than that, I'm not aware of any way to influence the name of the column generated by SSMS.

Marc

Answer 2

-- add a select ( first) and type (on the end), and as [something]

select
    ( 
    select 1 as tag,
    null  as parent,
    'algo'  as [nodo!1!attr]
    for xml explicit, type
    ) as [MyDesiredName]