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 »
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 »
In Microsoft SQL Server, there are different ways in which we can create the table. The table can be created with or without constraints. Basic Syntax for creating a table is, databaseName – Name of the DB where the table will be created tableName – Name of the table. columnName – Name of the column… Read More »
There are different types of statements that can be executed in SQL Server for different purposes. These are basically categorized into four types DDL – Data Definition Language DML – Data Manipulation Language DCL – Data Control Language TCL – Transaction Control Language DDL(Data Definition Language) The name itself suggests that it defines the structure… Read More »