Querying XML tag in SQL server

Question

I have a table Student with a column studentStateinfo which consist of XML value as below.

<params xmlns="">
  <OldStudentID>1aedghe1d8ef</OldStudentID>
</params>

Now when I query this table Student I only want to check whether studentStateinfo column have an XML data with tag <OldStudentID>

Mikael Eriksson · Accepted Answer · 2020-06-24 11:33:53Z

1

Example using a variable, you should change that to a column instead.

declare @X xml = '
<params xmlns="">
  <OldStudentID>1aedghe1d8ef</OldStudentID>
</params>';

select @X.exist('/params/OldStudentID');

answered Jun 24, 2020 at 11:33

Mikael Eriksson

139k22 gold badges223 silver badges293 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1