June 20, 2012 at 3:24 pm
Hi, I need to take a stored procedure that currently returns a simple and small record set, and change it to return JSON as an nvarchar(MAX) instead. There seem to be a good articles out there on how, but my knowledge of C# and Visual Studio is miniscule, so I'm missing some basic steps. Can someone help me bridge the gap between these two?
and
http://www.sqlservercentral.com/articles/CLR/74160/
Or, if it's not much harder, I'd like to see if I can implement the CLR using fastJSON, as that seems to have much better performance.
http://www.codeproject.com/Articles/159450/fastJSON
I'm using SQL Server 2008 R2 and Visual Studio 2010 btw, thanks in advance!
June 20, 2012 at 3:31 pm
Rekonn (6/20/2012)
Hi, I need to take a stored procedure that currently returns a simple and small record set, and change it to return JSON as an nvarchar(MAX) instead. There seem to be a good articles out there on how, but my knowledge of C# and Visual Studio is miniscule, so I'm missing some basic steps. Can someone help me bridge the gap between these two?and
http://www.sqlservercentral.com/articles/CLR/74160/
Or, if it's not much harder, I'd like to see if I can implement the CLR using fastJSON, as that seems to have much better performance.
http://www.codeproject.com/Articles/159450/fastJSON
I'm using SQL Server 2008 R2 and Visual Studio 2010 btw, thanks in advance!
To make it easier for others to get to the referenced url's:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply