Re: SQL2005, validation, & XQuery

Hello Mark,

Sorry for some mistyping in the post.

The statement should like this:

SELECT xml_col.value('declare namespace t1="http://ex.org/test";;
(/t1:test)[1]', 'varchat(50)') from xml_test

Hope it will be helpful.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages