User-Defined Data Types (UDT)

doesn’t support common language runtime (CLR) user-defined data types (UDTs).

To use

with CLR user-defined data types, make sure that the data type has an XML

serialization, and use an explicit cast to XML in the

select clause.

FOR XML support for various SQL Server data types

FOR XML
FOR XML
FOR XML