Introduction to JSON in SQL Server 2016 Part1

SQL 2016 New features
In this video we will go over quick introduction to JSON and How SQL Server converts SQL data types to JSON data types.

[JovanPopovicJocaPC]

There is one problem with your code. Behavior of FOR JSON is slightly changed in CTP3.2. SELECT getdate() as date FOR JSON PATH in your example returns {"date":"2016-07-02..."}However, in CTP3.2 and higher it will return result surrounded with brackets is new option without_array_wrapper that removes racket and returns a single object see MSDN docs and SQL server Database Engine Blog posts about JSON.

[YoeXCheneguein]

What version of sql server you are using?