Json to table in SQL Server 2008

Question

I want to insert below data into a SQL Server table

{ 
    "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| SHIPPED_DATE | STATUS | SOURCE

CSC-ENVM |1995-08-22T00:00:00| Shipped | Shipment

NP-2R |1995-03-14T18:23:00|Shipped |Shipment**

SQL Server 2008 has no direct, built-in support for JSON. You need to use some other tool - a language like C#, Ruby, PHP or whatever you're comfortable with - to read this JSON, convert it to objects, and then insert those objects and their values into SQL Server — marc_s
– marc_s, Commented Oct 6, 2016 at 10:30
Just use a regular INSERT statement, targeting a varchar/nvarchar column of the needed maximum length. — Dan Guzman
– Dan Guzman, Commented Oct 6, 2016 at 10:34

TheGameiswar · Accepted Answer · 2016-10-06 10:44:10Z

1

Just insert into table of a column with Varchar column as mentioned in comments as well

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"
}'

In SQL 2008,you also can read this JSON data using ParseJson function created by Phil Factor.you can read on about that here...

Consuming JSON Strings in SQL Server

answered Oct 6, 2016 at 10:44

TheGameiswar

29k9 gold badges67 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Json to table in SQL Server 2008

**ITEM_NUMBER| SHIPPED_DATE | STATUS | SOURCE

CSC-ENVM |1995-08-22T00:00:00| Shipped | Shipment

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

**ITEM_NUMBER| SHIPPED_DATE | STATUS | SOURCE

CSC-ENVM |1995-08-22T00:00:00| Shipped | Shipment

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related