Home Forums Programming XML XQUERY syntax question; how do i extract the GUID? RE: XQUERY syntax question; how do i extract the GUID?

  • The nodes specs and name have a namespace. You can use * as wildcard character for a namespace or you can use WITH XMLNAMESPACES (Transact-SQL).

    .value('(/includeSelectionItemsTemp/ArrayOfObjectSelector/ObjectSelector/*:specs/*:name/text())[1]', 'uniqueidentifier')