This category contains all SQL related articles
To change the collation of an database following commands can be used: ALTER DATABASE [database name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE [database name] COLLATE Newcollation ALTER DATABASE [database name] SET MULTI_USER For example […]
SQL FUNCTION: – Function in a database can be defined as the code segment consisting of a logical group of
ACID Rules This article will tell about the ACID Rules in SQL Server. It is a concept for evaluation of databases and their architecture.
Different Types of Sql Statements:- DML DML is abbreviation of Data Manipulation Language. It is used to retrieve, store,
We often need to change the name of a column of a table to a new name. We can do
Group By:- Group By clauses is used to groups rows based on the distinct values of the specified columns. The
Both Having Clause and Where clause is used to filter the data coming from the Select statement, but still there
Difference Between Having and Where Clause in Sql Server Read Post »
Sometimes duplicate values in tables can create a major problem when we do not make a primary key or a
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)
Third Normal Form (3NF) :- A table is said to be in the Third Normal form (3NF) if it satisfy
First Normal Form (INF) A table is said to be in a First Normal Form (1NF) if it satisfy the
Database Normalization Normalization Database Normalization can be defined as the process of organization the data to reduce the redundant table
Indexes-Indexing is way to sort and search records in the table. It will improve the speed of locating and retrieval
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 »