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
