Incorrect syntax near 'JSON' - SQL Server 2016

Question

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

Run this query ALTER DATABASE database_name SET COMPATIBILITY_LEVEL = 130. Source : MSDN — Pரதீப்
– Pரதீப், Commented Jan 30, 2016 at 17:51
Did you check the link i added in previous comment. It should work if you are using Sql Server 2016 — Pரதீப்
– Pரதீப், Commented Jan 30, 2016 at 18:01
So you are using SQL Server 2016 management studio but connecting to a 2014 instance. — Martin Smith
– Martin Smith, Commented Jan 30, 2016 at 19:10

Amjad · Accepted Answer · 2017-10-31 20:29:39Z

23

Check if compatibility level is set to SQL Server 2016 or 130
Connect to a 2016 instance instead of the older one. (Migrate DB)

Thanks to Martin and VR46

edited Oct 31, 2017 at 20:29

user330315

answered Jan 30, 2016 at 23:25

Amjad

1,6875 gold badges22 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Pரதீப் Over a year ago

Mark it as answer :)

Amjad Over a year ago

Done. Thanks again. :)

Brian Salehi Over a year ago

what if database says: Valid values of the database compatibility level are 100, 110, or 120.

Brian Salehi Over a year ago

version: Microsoft SQL Server 2014 and I'm using SQL Server 2016 Management Studio

Collectives™ on Stack Overflow

Incorrect syntax near 'JSON' - SQL Server 2016

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related