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?
http://blog.sqlauthority.com/2008/10/19/sql-server-introduction-to-clr-simple-example-of-clr-stored-procedure/
and
http://qa.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!