CODE EXAMPLE FOR SQL

row to json in sql server

SELECT * 
FROM MyTable  
FOR JSON PATH, WITHOUT_ARRAY_WRAPPER