... not respectively
SELECT Event_XML.exist('(/*/*[1][contains(local-name(.),"NAME")])')
FROM [dbo].[XML_EVENTS]
-- query() returns XML branch if the node name contains string "NAME" -- returns LIPMAN
SELEC ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.