json type in sql server 2016 code example Example: json in sql server SELECT name, surname FROM emp FOR JSON AUTO;