SQL

current selection doesn’t contain unqiue column – solved

Hello buddy, I hope you are doing well in this article we will see how we can fix the above…

Read More »

SQL Server Date Functions

This page lists the most commonly used SQL Server Date functions that allow you to handle date and time data…

Read More »

SQL Server ALTER TABLE ADD Column

In this tutorial, you will learn how to use SQL Server ALTER TABLE ADD statement to add one or more columns to…

Read More »

Database Normalization in SQL Server

In this article, I am going to discuss Database Normalization in SQL Server with real-time examples. What is Normalization? Database normalization is…

Read More »

Entity Framework VS Stored Procedure

in this tutorial, you will learn what is important in terms of Development Time Or Performance between Entity Framework VS…

Read More »

SQL Server Self Join

In this tutorial, you will learn how to use a special kind of join called SQL self Join to join a table…

Read More »

SQL UNION vs UNION ALL

UNION ALL command is equal to UNION command, except that UNION ALL selects all the values. The difference between Union and Union all is that Union all will not eliminate duplicate…

Read More »

Difference between Clustered and Non-Clustered Indexes in SQL Server?

Indexes are used to speed-up query process in SQL Server, resulting in high performance. They are similar to textbook indexes.…

Read More »

Triggers in SQL Server

In this post, I will show you what are triggers and how we can use triggers in SQL server. SQL…

Read More »

Difference between a CTE and a Temp Table?

Temp Table or CTE are commonly used for storing data temporarily in SQL Server. In this article, you will learn…

Read More »