SQL Server XML Declare Namespace

Question

I would like to have a few namespaces available by default when running an XQuery in SQL Server 2005, is this possible?

For example, I would like to do the following:

select * from TableWithXML
where
FieldWithXML.exist(
declare namespace nsp="http://www.example.com/exampleNamespace";
nsp:root/nsp:childnode) = 1

Without having to redeclare the namespace each time, so that SQL will recognize nsp without me including the prolog each time.

Thoughts?

Zoltan Toth · Accepted Answer · 2012-08-14 10:49:15Z

1

The xml and xsi namespaces are the only pre-defined namespaces that you do not have to declare yourself. All other namespaces must be explicitally declared in every query.

There are two ways to declare namespaces:

via the declare statement inside the XQuery.
via the WITH XMLNAMESPACES clause on the TSQL statement.

edited Aug 14, 2012 at 10:49

Zoltan Toth

47.8k12 gold badges132 silver badges138 bronze badges

answered Oct 22, 2009 at 19:53

Remy Lebeau

609k36 gold badges516 silver badges875 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Server XML Declare Namespace

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related