none
JSON to SQL Server

    Question

  •  

    Hi,

      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.

     

    Regards,

    Mike

     

    Wednesday, December 05, 2007 3:41 AM
    Moderator
  • 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