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 ???
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.
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
JSON support is added in SQL Server 2016 https://msdn.microsoft.com/en-us/library/dn921897.aspx
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?