Incorrect syntax near 'JSON' - SQL Server 2016 Incorrect syntax near 'JSON' - SQL Server 2016 json json

Incorrect syntax near 'JSON' - SQL Server 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