Home Forums SQL Server 2005 T-SQL (SS2K5) 'ROOT' directive in SELECT query RE: 'ROOT' directive in SELECT query
Ramesh Lende
Ten Centuries
Points: 1034
More actions
December 19, 2007 at 9:54 am
#761467
I tried with RAW this also fails...
SELECT * FROM customer FOR XML RAW, ELEMENTS,
root('customers')