How to convert json in sql server using For Json
Select * from Employee
for json path
Output
[{"EMP_ID":1,"EMP_NAME":"TEST1","EMP_SALARY":50000},{"EMP_ID":2,"EMP_NAME":"TEST2","EMP_SALARY":45000},{"EMP_ID":3,"EMP_NAME":"TEST3","EMP_SALARY":55000},{"EMP_ID":4,"EMP_NAME":"TEST4","EMP_SALARY":50000},{"EMP_ID":5,"EMP_NAME":"TEST5","EMP_SALARY":40000}]
Select * from Employee
for json path
Output
[{"EMP_ID":1,"EMP_NAME":"TEST1","EMP_SALARY":50000},{"EMP_ID":2,"EMP_NAME":"TEST2","EMP_SALARY":45000},{"EMP_ID":3,"EMP_NAME":"TEST3","EMP_SALARY":55000},{"EMP_ID":4,"EMP_NAME":"TEST4","EMP_SALARY":50000},{"EMP_ID":5,"EMP_NAME":"TEST5","EMP_SALARY":40000}]