In this article, you will learn how to validate JSON with ISJSON function introduced in SQL Server 2016.
This is one of the new features of SQL Server 2016. Before this article, I would like you to go through one of the previous articles on the Split_String function in SQL Server 2016.
I hope you love this new feature of SQL Server. Let’s move on to the ISJSON() function. What is JSON? JSON (JavaScript Object Notation) is a text based format, used for data exchange. It is lightweight compared to XML and thus is preferred as a best choice to transfer the data across the devices. It is open and readable. We can parse JSON by JavaScript implementations. Because of a few of these features, the developers prefer JSON over XML these days. JSON Syntax Here, I will show what JSON looks like:
SQL Server 2012 Functions Recipes