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.
"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
