>>Hi,
>>
>>I am trying to understand the terms or names used when creating a SELECT from XML file in SQL Stored Procedure.
>>
>>Here is an example:
>>
>>
>>SELECT [SomeName2].value('.','char(15)') FROM @XmlDoc.nodes('/ROOTNAME/Elem') SomeName1([SomeName2])
>>
>>
>>In the above SELECT expression the "SomeName1" is referred to only in one place. And it does not seem to matter what you name it, it works. What is this "SomeName1"?
>>
>>And then there is a name SomeName2. Looks like an alias of SomeName1. And this one, SomeName1 is referred to in every column of the SELECT. What would you call it?
>>
>>If you know of an on-line article that describes these terms, please let me know.
>>
>>TIA.
>
>SomeName1 is the alias for the table and SomeName2 is the alias for the XML field. E.g. Nodes produce a table. Since you're selecting from it, you don't need to prefix Select SomeName1.SomeName2.value
>
>but you can.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham