JSON is supported inward SQL Server too it is real slow to obtain JSON formatted reply from a interrogation easily. For example, piece connected to Northwind database you lot acquire the JSON formatted information past times running a interrogation such equally this 1 using the Products table: --------------------------------- SELECT ProductName, QuantityPerUnit, UnitPrice FROM Products FOR JSON Auto; --------------------------------- The reply volition hold out equally shown: JSON_0 You could besides provide a unmarried row of information equally shown past times running this query: ----------------------- SELECT [ProductID] ,[ProductName] FROM [Northwind].[dbo].[Products] WHERE ProductID=5 For JSON AUTO ------------------------- JSON_1 The effect comes inward an array fifty-fifty if the returned information is simply 1 ...