skip to Main Content

Parse Data from OPENJSON() to extract values

Here is my code: SELECT * FROM OPENJSON ('{"AFN":{"code":"AFN","name":"Afghan Afghani","decimal_digits":0,"name_plural":"Afghan Afghanis","rounding":0,"symbol":"Af","symbol_native":"؋"},"ALL":{"code":"ALL","name":"Albanian Lek","decimal_digits":0,"name_plural":"Albanian lekë","rounding":0,"symbol":"ALL","symbol_native":"Lek"},"AMD":{"code":"AMD","name":"Armenian Dram","decimal_digits":0,"name_plural":"Armenian drams","rounding":0,"symbol":"AMD","symbol_native":"դր."},"ANG":{"code":"ANG","name":"NL Antillean Guilder","decimal_digits":2,"name_plural":"NL Antillean Guilders","rounding":0,"symbol":"ƒ","symbol_native":"NAƒ"},"AOA":{"code":"AOA","name":"Angolan Kwanza","decimal_digits":2,"name_plural":"Angolan Kwanza","rounding":0,"symbol":"Kz","symbol_native":"Kz"},"ARS":{"code":"ARS","name":"Argentine Peso","decimal_digits":2,"name_plural":"Argentine pesos","rounding":0,"symbol":"AR$","symbol_native":"$"},"AUD":{"code":"AUD","name":"Australian Dollar","decimal_digits":2,"name_plural":"Australian dollars","rounding":0,"symbol":"AU$","symbol_native":"$"},"AWG":{"code":"AWG","name":"Aruban Florin","decimal_digits":2,"name_plural":"Aruban Florin","rounding":0,"symbol":"Afl.","symbol_native":"Afl."},"AZN":{"code":"AZN","name":"Azerbaijani Manat","decimal_digits":2,"name_plural":"Azerbaijani manats","rounding":0,"symbol":"man.","symbol_native":"ман."},"BAM":{"code":"BAM","name":"Bosnia-Herzegovina Convertible Mark","decimal_digits":2,"name_plural":"Bosnia-Herzegovina convertible marks","rounding":0,"symbol":"KM","symbol_native":"KM"},"BBD":{"code":"BBD","name":"Barbadian Dollar","decimal_digits":2,"name_plural":"Barbadian Dollars","rounding":0,"symbol":"Bds$","symbol_native":"$"},"BDT":{"code":"BDT","name":"Bangladeshi Taka","decimal_digits":2,"name_plural":"Bangladeshi takas","rounding":0,"symbol":"Tk","symbol_native":"৳"},"BGN":{"code":"BGN","name":"Bulgarian Lev","decimal_digits":2,"name_plural":"Bulgarian leva","rounding":0,"symbol":"BGN","symbol_native":"лв."},"BHD":{"code":"BHD","name":"Bahraini Dinar","decimal_digits":3,"name_plural":"Bahraini…

VIEW QUESTION

For Unity, how do I serialize a Json string file path and load it into a ScriptableObject asset like sprites?

//Json-------------------------- [ { "name": "Generic Ability", "icon": "Assets/Database/Images/default.png" }, { "name": "Another Ability", "icon": "Assets/Database/Images/another.png" } ] //Ability-------------------------- [System.Serializable] public class Ability { public string abilityName; public Sprite icon; } //AbilityDatabase-------------------------- using UnityEngine; using System.Collections.Generic; [CreateAssetMenu(fileName = "AbilityDatabase", menuName =…

VIEW QUESTION

Json – BEGIN_ARRAY but was STRING at line 1 column 1 java android sketchware

OnResponse code : card_list = new Gson().fromJson(_response, new TypeToken>>(){}.getType()); if (card_list.size() > 5) { recyclerview1.setAdapter(new Recyclerview1Adapter(card_list)); }else{ SketchwareUtil.showMessage(getApplicationContext(), _response); } Json 200 Result like : { "user": [ { "id": "string", "address": "string", "contact": "string", "name": "string", "description": "string", "image_url":…

VIEW QUESTION
Back To Top
Search