SQL : How to parse XML encoded as UTF-8 from a NVARCHAR(MAX) attribute?

SQL : How to parse XML encoded as UTF-8 from a NVARCHAR(MAX) attribute?
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

So here is a secret hidden feature I promissed to tell you.
This is a YouTube's feature which works on Desktop.
First, Make sure this video is playing.
Next, enter the letters 'awesome' on your keyboard.
Your YouTube progress indicator will turn into a shimmering rainbow.

A brief introduction of myself,
Hi, my name is Delphi, nice to meet you.
Allow me to provide support in answering your questions.
SQL : How to parse XML encoded as UTF-8 from a NVARCHAR(MAX) attribute?
I welcome your comments and chats if you have more detailed queries.
We welcome your thoughts and feedback, so please comment below with your answer or insights to the answer.
Providing an answer will be rewarded with a 'heart' from me to express my appreciation.
: parse UTF-8 to encoded XML NVARCHAR(MAX) How a from attribute? as SQL