Using WITH XMLNAMESPACES

My fellow Microsoft Mike (Michael Rys) has just posted an article on his blog highlighting the use of the new T-SQL with xmlnamespaces syntax. This syntax allows you to simplfy your XQuery statements by defining namespaces in the T-SQL world and having them available to all the XQuery expressions in the statement.

The new WITH XMLNAMESPACES clause