How to rename a Table in Sql Server
To rename a column in a SQL Table following command can be reused: SP_RENAME ‘old table name’, ‘New table name’…
How to change the database collation
To change the collation of an database following commands can be used: ALTER DATABASE SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER…
ACID Rules in Sql Server
ACID Rules This article will tell about the ACID Rules in SQL Server. It is a concept for evaluation of…
DML, DDL, DCL, TCL in SQL Server
Different Types of Sql Statements:- DML DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify,…
Renaming a column in Sql Server
We often need to change the name of a column of a table to a new name. We can do…
Group by…..Having Clause
Group By:- Group By clauses is used to groups rows based on the distinct values of the specified columns. The…
Second Normal Form (2NF)
Second Normal Form (2NF) :-A table is said to be in its Second Normal Form if it satisfied the following…
Third Normal Form (3NF)
Third Normal Form (3NF) :- A table is said to be in the Third Normal form (3NF) if it satisfy…
First Normal form (INF)
First Normal Form (INF) A table is said to be in a First Normal Form (1NF) if it satisfy the…
Database Normalization
Database Normalization Normalization Database Normalization can be defined as the process of organization the data to reduce the redundant table…