Pretty Format JSON in SQL Server

Transact-SQL
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