SQL Server supports JSON through the data type NVARCHAR(MAX).
XML: SQL Server supports the XML (Extensible Markup Language) data type. This data type allows you to store XML in a table column. XML documents contain one root that is the parent of all elements. The following is an example of XML syntax:
<books>
<book>
<name>Learn SQL Programming</name>
<author>Josephine Bush</author>
</book>
</books>
For more information about the SQL Server XML data type, visit https://docs.microsoft.com/en-us/sql/relational-databases/xml/xml-data-type-and-columns-sql-server?view=sql-server-ver15.
XML doesn't exist in MySQL; use the BLOB data type instead. See the String Data Types section for more information on the BLOB data type.