SQL

row to value to json in sql server

SELECT BusinessEntityID As Id,  
       FirstName, LastName,  
       Title As 'Info.Title',  
       MiddleName As 'Info.MiddleName'  
   FROM Person  
   FOR JSON PATH, ROOT('info'),INCLUDE_NULL_VALUES

row to json in sql server

SELECT * 
FROM MyTable  
FOR JSON PATH, WITHOUT_ARRAY_WRAPPER