Hello,
Could anybody tell me if it's possible to named the result of this query?
SELECT User_Id, Name, Surname, Age, Nationality
FROM [Basic Data] FOR XML PATH, TYPE, elements, root('AllPrimaryData')
The result of this query is an XML Document in a column without a name and I'm trying to name it but I can't.
Could anybody help me with that?
Thanks a lot.
I'm not sure if this will work, but try:
SELECT
User_Id as "@.UserId",
Name as "@.Name",
Surname as "@.SurName",
Age as "@.Age",
Nationality as "@.Nationality"
FROM [Basic Data]
FOR XML PATH, TYPE, elements, root('AllPrimaryData')|||
Try something like this:
select nameOfColumn from (
SELECT User_Id, Name, Surname, Age, Nationality
FROM [Basic Data] FOR XML PATH, TYPE, elements, root('AllPrimaryData')
as myXMLTable(nameOfColumn)
or do it with a CTE:
with myXMLTable(nameOfColumn) as (
SELECT User_Id, Name, Surname, Age, Nationality
FROM [Basic Data] FOR XML PATH, TYPE, elements, root('AllPrimaryData')
)
select nameOfColumn
from myXMLTable
Steve Kass
Drew University
www.stevekass.com
Hi,
Thanks for your response, but it doesn't work.
|||Thanks a lot Steve, your first proposal works fine!
No comments:
Post a Comment