skip to Main Content

SQL Server: Transform arrays of JSON objects into table format

Following is the given JSON data: DECLARE @Jdata NVARCHAR(MAX) = '{ "EmployeeDetails": { "BusinessEntityID": 3, "NationalIDNumber": 509647174, "JobTitle": "Engineering Manager", "BirthDate": "1974-11-12", "MaritalStatus": "M", "Gender": "M", "StoreDetail": { "Store": [ { "AnnualSales": 800000, "AnnualRevenue": 80000, "BankName": "Guardian Bank", "BusinessType": "BM",…

VIEW QUESTION

Enterprise Redis JSON.GET Syntax for JSONARRAY contains

I'am looking what functionalities that Redis Enterprise can offer, and came up with following questions. Content in JSON using JSON.Set JSON.SET warehouse:1 $ '{ "city": "Boston", "location": "42.361145, -71.057083", "inventory": [ { "id": 15970, "gender": "Men", "season":["Fall", "Winter"], "description": "Turtle…

VIEW QUESTION
Back To Top
Search