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 article you will learn how to Implement UPSERT () Method in C#.

In this article, we will discuss the concept of Inserted and Deleted tables in SQL.

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

SPARSE column is ordinary type column that has an optimized storage for NULL values.

This article will discuss 11 important database designing rules.

One of the friends in C-sharpcorner has asked me for help displaying the difference of data from two different data sources.

This article shows how to use a SQL query to perform searching, sorting and paging by one query.

In this article series, we will understand a few important concepts to develop projects in SQL Server CLR. Please don't be confused by the name SQL-CLR, It's nothing but a SQL Server CLR pr...

In this article I will briefly describe a subquery vs a correlated subquery in SQL.

I have reviewed and answered many articles related to SQL Server. For the previous one and a half months, I found 3 to 4 articles related to finding comma separated values in SQL Server. So I decid...

This article explains the execution order of triggers In SQL.

Here you will learn how to kill active SQL Server DB Connections.

This article explains how to get a monthly attendance report using a Stored Procedure in SQL.

In this article we will see how to create a Array variable in SQL and how to iterate through it to process records in database.

In this article I will demonstrate how to use optional parameters in a Stored Procedure in SQL.

In this article I am going to explain how to validate data within a stored procedure.

In this article we learn how to use Service Broker and triggers to capture data changes.

In this article you will learn how to use SQL Profiler and database Tuning Advisor to improve the performance of a database.

This article is intended to illustrate the concepts of materialized views in database systems and their realization through examples written for SQL Server and Oracle database systems.