sql-server - Json 到 SQL Server 2008 中的表

Question

我想将以下数据插入到 SQL Server 表中

{ 
    "ITEM_NUMBER":"CSC-ENVM",
    "SHIPPED_DATE":"1995-08-22T00:00:00",
    "STATUS":"Shipped",
    "SOURCE":"Shipment"
},
{ 
    "ITEM_NUMBER":"NP-2R",
    "SHIPPED_DATE":"1995-03-14T18:23:00",
    "STATUS":"Shipped",
    "SOURCE":"Shipment"
}

**ITEM_NUMBER|发货日期 |状态 |来源

CSC-ENVM |1995-08-22T00:00:00|已发货 |装运

NP-2R |1995-03-14T18:23:00|已发货 |发货**

Answer 1

如评论中所述，只需将具有 Varchar 列的列插入到表中

insert into #temp
select '{ 
    "ITEM_NUMBER":"CSC-ENVM",
    "SHIPPED_DATE":"1995-08-22T00:00:00",
    "STATUS":"Shipped",
    "SOURCE":"Shipment"
},
{ 
    "ITEM_NUMBER":"NP-2R",
    "SHIPPED_DATE":"1995-03-14T18:23:00",
    "STATUS":"Shipped",
    "SOURCE":"Shipment"
}'

在 SQL 2008 中，您还可以使用 Phil Factor 创建的 ParseJson 函数读取此 JSON 数据。您可以在此处阅读有关内容...

Consuming JSON Strings in SQL Server