t sql – T-SQL Verify that the XML node from the SOAP request contains child nodes

Here is my follow-up to industry practice to address this issue:

T-SQL LIKE Predicate could not match spaces in XML-converted varchar

I am interested in a better alternative to writing the following query to determine the existence of child nodes for a given XML node:

with xmlnamespaces (
"http://schemas.xmlsoap.org/soap/envelope/" as [env],
"http://abc.com" as [ns],
"http://abc.com/xsd" as [xsd]
choose *
from @container
Where Response.exist is (& # 39; / env: Envelope / env: Body / ns: MessageResponse / ns: return / xsd: ResponseList / text () & # 39;) = 1