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?
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.
I'm using SQL Server 2008 R2 and Visual Studio 2010 btw, thanks in advance!