Select values from XML field in SQL Server 2008

by

Given that the XML field is named ‘xmlField’…

SELECT 
[xmlField].value('(/person//firstName/node())[1]', 'nvarchar(max)') as FirstName,
[xmlField].value('(/person//lastName/node())[1]', 'nvarchar(max)') as LastName
FROM [myTable]

More Related Contents:

  1. SQL Server Xml query with multiple namespaces
  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 select next n letters after one specific letter using function in sql server by giving function name,specific letter, no of letters next
  15. SQL server query to output the data shown below
  16. Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
  17. What is the difference between Integrated Security = True and Integrated Security = SSPI?
  18. How to execute XPath one-liners from shell?
  19. How to use a variable for the database name in T-SQL?
  20. What is the difference between char, nchar, varchar, and nvarchar in SQL Server?
  21. Why is 1899-12-30 the zero date in Access / SQL Server instead of 12/31?
  22. RODBC odbcDriverConnect() Connection Error
  23. Calling an API from SQL Server stored procedure
  24. Is there a way to not use square brackets in SQL Server?
  25. How do you set autocommit in an SQL Server session?
  26. Default XML namespace, JDOM, and XPath
  27. Avg of float inconsistency
  28. How to apply the XPath function ‘substring-after’
  29. Is there an “IF EXISTS” test for a linked server?
  30. SQL Server stored procedure return code oddity

Leave a Comment