JSON to SQL Server




      Is it possible to insert JSON data to SQL Server directly using stored procedure?


    Somthing like for XML we are using sp_xml_preparedocument and openxml. For JSON ???

    Monday, December 03, 2007 8:44 AM

All replies

  • To my knowledge there is not built-in procedures to import JSON. You might ask the folks in the T-SQL forum, but I'm fairly confident the answer is no. I'm sure you could write a procedure to do so though.





    Wednesday, December 05, 2007 3:41 AM
  • Yes Mike,


       I also searched in lot of articles. They said that you have to write own .NET CLR function like openxml to store JSON data. Any one guide me how to write .NET CLR function for SQL Server 2005?...



    Thanks in Advance 


    Thursday, December 06, 2007 5:13 AM
  • JSON support is added in SQL Server 2016

    Thursday, October 29, 2015 1:16 PM