How to write the generated xml document to a string?

Question

SQL Server

I generated an xml document using the for xml function, where can I save the result? When trying to add insert into / select into to the query or assigning the result to a variable, it says that these constructs cannot be used with for xml. How to proceed then?

Answer 1

Declare @xml as xml
, @str as nvarchar(max)
select @xml = (select ... for xml)
select @str = cast(@xml as nvarxhar(max))

Answer 2

Data Type Conversion .

What into what: