"Antanas" <An*********@yahoo.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...
The following CarsElement XML data type is passed in CTE. Can XML data
type be passed as out parameter for SQL stored procedure or returned in
SQL UDF.
WITH CarsDef(CarsElement) as
(SELECT
XMLELEMENT ( NAME "Cars",
XMLELEMENT (NAME "CarMake", CAR_MAKE),
XMLELEMENT (NAME "CarID", CAR_COLOR)
)
FROM AUTOS WHERE CAR_COLOR='Red'
)
Wouldn't it be faster to try this yourself with a small prototype in a test
database than to ask us? Most of us have probably never tried to do what you
want and have no idea what the answer is. You might wait days before getting
an answer here; you could probably set up a small prototype and get an
answer in 20 minutes.
I'm not saying this to discourage your question, just to save you some time.
Rhino