Convert Sql select statement result into JSON formate .

Formats the query result as JSON using the 'FOR JSON PATH' mode, where you have full control over the JSON structure by using column aliases.

SQL Query:-

SELECT 

    FirstName,

    LastName

FOR JSON PATH, WITHOUT_ARRAY_WRAPPER

JSON Output- 

{"FirstName":"Ajit","LastName":"Agarwal"}