This category contains all SQL related articles
Sometimes duplicate values in tables can create a major problem when we do not make a primary key or a […]
How to find duplicate values in a table Read Post »
Views:- View can be described as virtual table which derived its data from one or more than one table columns.It
Second Normal Form (2NF) :-A table is said to be in its Second Normal Form if it satisfied the following conditions:- 1)
Second Normal Form (2NF) Read Post »
Third Normal Form (3NF) :- A table is said to be in the Third Normal form (3NF) if it satisfy
Third Normal Form (3NF) Read Post »
First Normal Form (INF) A table is said to be in a First Normal Form (1NF) if it satisfy the
First Normal form (INF) Read Post »
Database Normalization Normalization Database Normalization can be defined as the process of organization the data to reduce the redundant table
Database Normalization Read Post »
Indexes-Indexing is way to sort and search records in the table. It will improve the speed of locating and retrieval
Indexes in Sql server Read Post »
Indexes-Indexing is way to sort and search records in the table. It will improve the speed of locating and retrieval
Difference between Clustered Index and Non clustered Index Read Post »
Introduction I generally feel that people are afraid of Joins in SQL Server. But if they know what the different
Sql Joins- Inner Joins, Self Joins, Outer Joins, Cross Joins Read Post »
In Sql Server, both functions and stored procedures can be defined as the logically grouping of Sql statements formed to
Sql Server- Difference between Stored Procedure and Function Read Post »
Although the Delete and Truncate Commands logically does the same work of deleting the rows from the table but still
Difference between Delete and Truncate Command Read Post »
Stored Procedure:- Stored Procedure In Sql server can be defined as the set of logically group of sql statement which
Sql Server – How to write a Stored procedure in Sql server Read Post »
Union and Union All, both are used to select data from one or more than one tables but still they
Sql Server – Union and Union All Read Post »
IDENTITY Property Sometimes we need a column whose values can uniquely identifying the rows in the table. To achieve
IDENTITY Property in SQL Server Read Post »
Database is made offline to move its physical files. There can be many ways to make a database offline. But
How to make database offline or online Read Post »
