Using FOR JSON in SQL Server 2016

Question

Is there any way i return JSON data in given below format using FOR JSON in SQL Server 2016?    { "draw": 1, "recordsTotal": 57, "recordsFiltered": 57, "data": [ { "first_name": "Airi", "last_name": "Satou", "position": "Accountant", "office": "Tokyo", "start_date": "28th Nov 08", "salary": "$162,700" } }   Thanks

Sanwar Ranwa · Answer

Hello   You can check these Links   https://cloudblogs.microsoft.com/sqlserver/2016/01/05/json-in-sql-server-2016-part-1-of-4/   https://www.red-gate.com/simple-talk/sql/learn-sql-server/json-support-in-sql-server-2016/   https://www.mssqltips.com/sqlservertip/4015/introducing-json-for-sql-server-2016/   https://www.c-sharpcorner.com/article/working-with-json-in-sql-server-2016/