Incorrect syntax near 'JSON' - SQL Server 2016

sql json sql-server-2016
Amjad picture Amjad · Jan 30, 2016 · Viewed 14k times · Source

So I recently installed SQL Server 2016 CTP3 mainly for the JSON output feature. I am trying to using it in my SQL Query exactly like how its shown in the link below on MSDN. The keyword JSON does not turn blue and gives error "Incorrect syntax near 'JSON'"

https://msdn.microsoft.com/en-us/library/dn921882%28v=sql.130%29.aspx?f=255&MSPPError=-2147217396

What could be wrong?

EDIT: I'm testing it with AdventureWorks DB for SQL Server 2016. The query is 

SELECT * FROM Person.Contact FOR JSON AUTO

Answer

Amjad picture Amjad · Jan 31, 2016
  1. Check if compatibility level is set to SQL Server 2016 or 130
  2. Connect to a 2016 instance instead of the older one. (Migrate DB)

Thanks to Martin and VR46

Related questions

Accessing JSON Array in SQL Server 2016 using JSON_VALUE

I am stuck while accessing array inside json using newly introduced JSON_VALUE function. Please consider following code - IF EXISTS(SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='JsonData') DROP TABLE JsonData; go CREATE TABLE JsonData(JsonData nvarchar(max)); …

Read More
SQL to JSON - array of objects to array of values in SQL 2016

SQL 2016 has a new feature which converts data on SQL server to JSON. I am having difficulty in combining array of objects into array of values i.e., EXAMPLE - CREATE TABLE #temp (item_id VARCHAR(256)) INSERT INTO #temp VALUES (…

Read More
How to check are there JSON Functions by SQL query?

There are JSON Function in SQL 2016 like JSON_VALUE, JSON_QUERY and other. I would like to use it in my queries, but I still have old servers with SQL 2014, for example, that are not allowed to use the new …

Read More