SQL Server Tutorial

SQL Server Copy Tables A copy table means making the clone or duplicate table of an existing table. The copy table must…

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 OFFSET FETCH This article will explain the use of OFFSET FETCH functionality in retrieving a record with limited memory and…

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 ORDER BY An ORDER BY clause is used to arrange the table’s data in ascending or descending order based on…

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…