Applies an XML query expression to an XML document and returns the specified result. Information can be returned with or without the XML tags.
See XML Services for syntax, examples, and usage information for xmlextract and all other Transact-SQL functions that support XML in the database.
