Post reply

EXPORT TO XML

  • January 27, 2004 at 11:16 am

    #108848

    Hi

    Can anyone please send me the T-SQL statement that enables you to export a table with its data to XML? Presently the only process I now is through meta-data services in the Enterprise MMC console & this is hardly scalable. Please help.

  • January 27, 2004 at 11:54 am

    #491808

    Look for the "FOR XML" clause in SQL Books Online.

    SELECT Field1, Field2

    FROM FOO FOR XML AUTO




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply