We help IT Professionals succeed at work.

New podcast episode! Our very own Community Manager, Rob Jurd, gives his insight on the value of an online community. Listen Now!

x

read Json fields and insert all the content into a table by Store Procedure

hidrau
hidrau asked
on
128 Views
Last Modified: 2017-04-10
Hello guys

I have to develop a store proc where I will pass a long json string,

I'd like to know what is the better way to insert all the stuff from json fields into a table, that is, to collect all the information
from my json fields and insert into a table that has the same field.

Is there any function in MSSQL that can read json?

I use the MS SQL 2008

thanks
Alexandre
Comment
Watch Question

Developer
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Hi,

I understood.

I got this code where it is created a function that can parse Json, it seems to be very good.

http://stackoverflow.com/questions/2867501/parse-json-in-tsql
Nitin SontakkeDeveloper
CERTIFIED EXPERT

Commented:
That's great!

Author

Commented:
thanks
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.