This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Please ignore this question.
I am just testing XML CDATA section in the source code.
So far, this site was not allowing to use XML CDATA section in the source code.
Feedback post: xquery-and-add-image-functionality-is-broken.html
UPDATE, Apr/14/2021
DECLARE @xml XML = N'<root><![CDATA[some text]]></root>';
SELECT @xml;
Hooray! It was fixed and, and it is working now. 😊
It still does not seem to permit CDATA. At least I don't see any source code with it.
Alas, one year plus of existence of this site is not enough to make it happen.
Please check the link in the question. You will see what I tried to post as an answer. And what error it gives.
While ugly, i guess you could do:
SELECT @cdata = 'CDATA['
And then use that variable when you post your solution. Would of course point out that the variable is only due to a limitation in the forum platform. Possibly you could add a "clean" solution as a screenshot.
I am closing this post.
It seems that the issue is resolved.
UPDATE
Unfortunately, we are back to square one. It seems that the fix was reverted.
It is still impossible to use the CData section on this forum.