There is a lot of limitation on for xml clause. Is it possible to combine
several select statement with for xml to a big xml file?
Basically I want to implement something like:
select ... for xml auto
union all
select ... for xml auto
union all
.....(select ...
union all
select ...)for xml auto
--
-Omnibuzz (The SQL GC)
http://omnibuzz-sql.blogspot.com/
Monday, March 26, 2012
How to use the return of select .... for xml auto...?
Labels:
auto,
clause,
combineseveral,
database,
filebasically,
limitation,
microsoft,
mysql,
oracle,
return,
select,
server,
sql,
statement,
xml
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment