Pretty Format JSON in SQL Server

Transact-SQL
1

There are tons of online formatter to format SQL, XML, JSON, etc... into structure.

Is there a way to PRETTY format JSON or XML in SQL Server?

2

image

declare @xml xml = 
'<note><to>Tove</to><from>Jani</from><heading>Reminder</heading><body>Don''t forget me this weekend!</body></note>'

select @xml

``

Then click on the result
1 Like