SQL Server Tutorial

Disable Primary key ALTER INDEX statement is used to disable a primary key in SQL Server database. Syntax: ALTER INDEX constraint_name ON…

SQL Server Insert Data INSERT statement in SQL Server is used for adding records in a table within the specified database. SQL…

SQL Server NULLIF The NULLIF function in SQL Server accepts two arguments and compares them to determine they are the same or…

SQL Server COUNT() Function The COUNT() function in SQL Server is a part of the aggregate function used for calculating the total…

SQL Server DISTINCT Clause In SQL Server, DISTINCT clause is used to remove duplicates from the table. The DISTICT clause is only…

SQL Server INSERT INTO SELECT It is not easy to insert data of one table into another in the same or different…

SQL Server OFFSET FETCH This article will explain the use of OFFSET FETCH functionality in retrieving a record with limited memory and…

SQL Server CREATE DATABASE A database is an organized collection of data that is structured into tables, rows, columns, and indexes. It…

SQL Server DROP Database Sometimes a database is not relevant or obsolete on our server instance. In that case, we can delete…

SQL Server INTERSECT Operator In SQL Server, the INTERSECT operator is used to fetch the records that are in common between two…