|
Home > Archive > MS SQL XML > July 2005 > Undeclared tag ID 2 is used in a FOR XML EXPLICIT query
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Undeclared tag ID 2 is used in a FOR XML EXPLICIT query
|
|
|
|
| Michael Rys [MSFT] 2005-07-25, 8:29 pm |
| If you are using [elt!2] where elt is the element name and 2 is the tag
number as a column alias in a FOR XML EXPLICIT query, you should use
[elt!2!] instead.
Best regards
Michael
"xoc" <xoc@discussions.microsoft.com> wrote in message
news:62835933-8EB8-4A40-96E1- DB6DCDEF83D8@microso
ft.com...
>I recently had this error occur and some web searching pointed in the
> direction that there is a known problem.
> See:
> http://www.msmcse.ms/archive/index.php/t-2017174.html
> http://www.tech-archive.net/Archive...04-08/0198.html
>
> Since this is being run on a hosting service server, it may be a while
> until
> SP4 is installed. I would like to understand the workaround mentioned,
> about
> using <elt!2!> instead of <elt!2>.
>
> Thanks for any help.
|
|
|
|
|