declare @T table ( XMLCol xml ) insert into @T (XMLCol) ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

declare @T table
(
  XMLCol xml
)

insert into @T (XMLCol)
select (
        select *
        from master..spt_values
        for xml auto, type
       )

select convert(varchar(max), XMLCol),
       datalength(XMLCol)
from @T

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results