Get result of sql query in JSON format via MSSQL

Question

I need to get result of sql query in JSON format via MSSQL 2014. I have wrote this code:

SELECT bc.Id, bc.CityName, bc.ProvinceId FROM BusCity AS bc WHERE bc.Country=2 FOR JSON AUTO

But I am getting an error:

Incorrect syntax near 'JSON'.

Is this possible? How to do this?

FOR JSON is not available with 2014. Here is an answer with an alternative approach stackoverflow.com/questions/6818441/… — Ric
– Ric, Commented Oct 23, 2017 at 10:37

Paul Alan Taylor · Accepted Answer · 2017-10-23 10:37:52Z

1

You running 2016 or higher?

FOR JSON was introduced then.

Type

SELECT @@Version

To find out what version you're running.

https://learn.microsoft.com/en-us/sql/relational-databases/json/format-query-results-as-json-with-for-json-sql-server

answered Oct 23, 2017 at 10:37

Paul Alan Taylor

10.7k1 gold badge30 silver badges44 bronze badges

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

2 Comments

hmahdavi Over a year ago

Microsoft SQL Server 2014 (SP2) (KB3171021) - 12.0.5000.0 (X64) Jun 17 2016 19:14:09 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

Paul Alan Taylor Over a year ago

Yup. It's not available on your version of SQL.

Collectives™ on Stack Overflow

Get result of sql query in JSON format via MSSQL

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related