Tag Archives: Microsoft SQL Server

Difference between ISNULL and COALESCE in SQL

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 »

Types of SQL Statements in MS SQL Server

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 »