... pretend the info we want is rather simple:
SELECT
[sequenceID],
[student_reference],
[student_title_code],
[student_name],
[student_gender_code],
...
...
INSERT
2014-03-27
Extracting the Gender:
We're going to extract the value in between the opening and closing XML tags:
-- Using .query()
SELECT
CAST(CAST(Event_XML ...
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.