This article presents a brief introduction to View and its impact on a .NET Application when the underlying table structure is changed.

How we can check and delete duplicate rows from a SQL server table using CTE (Common Table Expression)

This article shows you the basics of SQL Schema using the DDL statements.

This article shows how we can determine the size of an entire database using C# and the size of each and every table in the database using a single SQL command.

Normaliztion is the process of arranging and managing data

This article will discuss alternative methods for performing cascading deletes using LINQ to SQL. Cascading delete refers to the action of removing records associated by a foreign key relationship...

In this blog, we will discuss how to work with GROUP BY, WHERE and HAVING clause in SQL and explain the concept with an example in a simple way. I hope this is very useful for beginners and interme...

In this article you will learn how to make SQL Comments statement in SQL

In this blog, you will learn about the basic types of SQL statements with examples.

Common Table Expression in SQL Server offers a more readable form of the derived table, which can be declared once and referenced multiple times in a query.

In this article you will learn about SQL Data Types in detail.

What is SQL? SQL stands for Structured Query Language, a query language to access and update relational databases. In other words, if you need to read, insert, update, or delete data to a relationa...

SQL stands for Structured Query Language. SQL is a query language for relational databases that allows data definition, data access, and data manipulation functionality. In other words, if you need...

In this article, you will learn about PostgreSQL.

CTE (common table expression) and Updatable CTE

This article explains the various types of triggers.

In this article, you will learn how to use a SQL LIKE statement in SQL

Sometimes, we want to get a common set of rows from 2 different result sets. For example, we have 2 queries and both return employee records. If we want to find which employees are present in both ...

In this article, you will learn how to Unique Constraint in SQL.

In this article, you will learn how to create an Index statement in SQL.

In this article, you will learn how to use a Replace statement in SQL.

In this article you will learn about the SQL Exists statement

MS SQL Server manages large databases, and users often face multiple issues or errors with the databases.

Here, we will see how to create select, insert, update, delete SQL statements in stored procedures in SQL.

In this article you will learn how to use a SQL UPDATE statement