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: