Maddy

Maddy

  • NA
  • 81
  • 467

Using FOR JSON in SQL Server 2016

Oct 16 2018 5:28 AM
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
 

Answers (1)