How to Include Null Values in JSON Output in MSSQL

One of the top features of MSSQL server 2016 is built in support of JSON. The data from the MSSQL can be exported to JSON by adding the FOR JSON clause into a SELECT...