Last Thursday I presented my session “From XML to JSON” in the Application Development PASS Virtual Chapter. The session is about XML and JSON, two widely used markup languages, shared by many applications and data platforms. XML has been natively supported in SQL Server since 2005, and JSON is going to be supported in SQL Server 2016.
The session was 100% demo, in which I demonstrated how to use XML and JSON functionality in SQL Server in order to manipulate and transform data. I promised to share all the scripts I used in the demo, so here they are: