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 »
In the other article, we saw the usage of Table variables. In this article, we will see how to transform column values in a table to a comma-separated string. Let’s create a table variable “Teams” with the columns ‘ID’ and ‘Team’ (use the below script). When you fire a SELECT over the above table, it… Read More »
Table variables in SQL Server are variables that store a set of records in a table like structure for a particular period of time. It is another way of storing data temporarily similar to temporary tables. In this article, we will see what is table variable with an example. Generally, the name of the table… Read More »
A temporary table in SQL Server is a table that exists temporarily on the database server for a certain period of time. Temporary tables are basically stored inside the “tempdb”, which is a system database. Temporary tables are useful to work with a small subset of records in a table that contains a large number… Read More »
In SQL server, ALTER TABLE statement is used for the following purposes ADD columns/ constraints in the existing table. DROP columns/ constraints in the existing table. ALTER columns in the existing table. ENABLE/ DISABLE triggers. ADD columns/constraints Syntax to add columns and constraints while creating column Syntax to add column(s) One or more columns can… Read More »
Microsoft SQL Server provides a nice feature of creating a table on the fly along with the data from another table using “Select into” statement. Syntax columns – Columns to be retrieved from the existing table. newTableName – Name of the new table to be created. existingTableName – Source table with data. conditions – Conditions… Read More »