json functions sql server 2014 code example

Example: json in sql server

SELECT name, surname  
FROM emp  
FOR JSON AUTO;