JSON functions have been included with SQL Server 2016 and later, allowing data to be retrieved in JSON formats, as well as writing JSON documents to tables. By using these functions, data can be retrieved in a ready to use format by applications or sent to other trading partners. We'll discuss the basics of JSON, and demonstrate the use of SQL Server's built-in JSON functions.