A Function to Split JSON Data - SQLServerCentral

I believe you will find the JSON format easy to use and very readable, and the fnSplitJson2 function a very useful tool. I use this function to use one parameter instead of many parameters in stored procedures or functions, pass a data string into stored

www.sqlservercentral.com