In this post, I will explain JSON built in functions in SQL server to work with JSON string. The JSON built in functions introduced in SQL Server 2016 are, OPENJSON ISJSON JSON_VALUE JSON_QUERY JSON_MODIFY In the previous post, I explained OPENJSON function in detail with examples. Now, I will explain rest of the functions with… Read More »
In the previous article, I have explained about different ways to import JSON into SQL server. One of the ways is using OPENJSON function. In this article, I will explain OPENJSON function in SQL Server with some examples. OPENJSON is a table valued function that parses JSON document and transforms it into rows and columns.… Read More »
JavaScript Object Notation (JSON) is a lightweight data-interchange format. The JSON format is widely used to exchange data in most web and mobile applications. Also, the REST web services return results in JSON format. In this article, let’s see how to import JSON files into SQL Server. In SQL Server, you can import JSON documents,… Read More »
In this article, we will see the difference between ISNULL and COALESCE in SQL Server. Both ISNULL and COALESCE evaluates the expression for NULL and returns a non-null value. ISNULL The ISNULL function replaces NULL with a specified value. ISNULL ( check_expression, replacement_value ) It contains two parameters. The first parameter is to evaluate the… Read More »
In this article, let’s see various methods to implement pagination in SQL server. In SQL server database, a table can have N no of records. Populating all these records in a grid control slows down the web page. You need to divide the number of records and populate it in the web page. Pagination is… Read More »