On Sun, Dec 11, 2011 at 2:27 AM, Santosh V <[email protected]> wrote: > > 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 ??? --------------
No you will have to write the parser to transform json to the parameter values your SPROC expects. I don't think that writing it in TSQL is advantageous where you just pass in the text string that the json was. Second part is your business layer needs to accept the data and pass it back or message to the GUI what was incorrect. In that arena is where your parser should live. HTH -- Stephen Russell 901.246-0159 cell -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
