SQL Server Xml query with multiple namespaces

by

I know that answer is accepted, but there is actually simplier way of doing it, if the only thing you need to do is select node value. Just use * as namespace name:

SELECT MessageXml
     ,  MessageXml.value('(/*:Envelope/*:Body/*:FetchRequest/*:Contract/*:TransactionId)[1]'
                       , 'varchar(max)')
FROM   dbo.Message

More Related Contents:

  1. Select values from XML field in SQL Server 2008
  2. XML Server XML performance optimization
  3. Import ‘xml’ into Sql Server
  4. How to add xml encoding to xml Output in SQL Server
  5. How to query values from xml nodes?
  6. How to query for Xml values and attributes from table in SQL Server?
  7. Parse XML in SQL Server
  8. SQL Server – defining an XML type column with UTF-8 encoding
  9. Milliseconds wrong when converting from XML to SQL Server datetime
  10. Why do I get the error “Xml data type is not supported in distributed queries” when querying a linked server for non-xml data?
  11. Does the `nodes()` method keep the document order?
  12. Why insert-select to variable table from XML variable so slow?
  13. The Best Way to shred XML data into SQL Server database columns
  14. How to read XML using XPath in Java
  15. How can foreign key constraints be temporarily disabled using T-SQL?
  16. How to update large table with millions of rows in SQL Server?
  17. How do you specify a different port number in SQL Management Studio?
  18. Export table to file with column headers (column names) using the bcp utility and SQL Server 2008
  19. Sequence as default value for a column
  20. VarBinary vs Image SQL Server Data Type to Store Binary Data?
  21. Convert month name to month number in SQL Server
  22. Decimal values in SQL for dividing results
  23. Need help in calculation using two Datasets using Expression SSRS
  24. Why SQL Server DATETIME type saves time in ticks of 1/300 of a sec?
  25. Cannot bulk load. Operating system error code 5 (Access is denied.)
  26. Does query plan optimizer works well with joined/filtered table-valued functions?
  27. Generate table relationship diagram from existing schema (SQL Server) [closed]
  28. How do I generate a comma-separated list with XSLT/XPath?
  29. Bootstrapping SQL Express from WiX?
  30. CHECKSUM and CHECKSUM_AGG: What’s the algorithm?

Leave a Comment