How redirect SQL Sserver XML output?

  • Thread starter Thread starter vikys
  • Start date Start date
V

vikys

I have to generate an XMl from a SQL Server 2000 table. Using the clause FOR
XML i can only send the result to screen or to file.

I want, instead, store the result, into a field column in another table.
There's a way i can do it without passing through a file (and OpenXML), but
storing the result directly into the field column?

tnks in advance
 
insert into mytable (myfield1, myfield2)
select myfield1, (select myfield2 for XML)
from my happy table
 
Back
Top