以下はCSVをJSONに変換する単純な例です。各CSVレコードは1つのJSONオブジェクトで構成される1つの出力行に変換されます。
SELECT * FROM CSV_TO_JSON ( ON (SELECT csvFile FROM myCSVTable09 WHERE id=2) USING SCHEMA('{"record_delimiter":"#"}') ) AS csvJSON ORDER BY data."Item ID"; > {"Item_ID":"55", "Item_Name":"bicycle", "Item_Color":"red", "Item_Style":"boys", "Quantity_Purchased":"1", "Item_Price":"100.00", "Total_Price":"100.00"} > {"Item_ID":"88", "Item_Name":"toy boat", "Item_Color":"pink", "Item_Style":null, "Quantity_Purchased":"1", "Item_Price":"15.10", "Total_Price":"15.10"} > {"Item_ID":"105", "Item_Name":"soap", "Item_Color":null, "Item_Style":null, "Quantity_Purchased":"1", "Item_Price":"0.99", "Total_Price":"0.99"}