SQL Server - FOR XML EXPLICIT and CDATA, XML and XMLTEXT attributes

This is the follow-up post on FOR XML EXPLICIT that I promosed in the previous post. We saw some of the basics of FOR XML EXPLICIT in the previous post. Let us see a few more interesting usages of FOR XML EXPLICIT in this post.