SQL SERVER – Data types
Data types in SQL Server In relational database, we store data in tabular form where data is divided into columns. Each column has a name...
SQL Server – Convert() function
Convert () function in SQL Server Convert () function is used to convert an expression from one data type to another data typeSyntax for CONVERT function CONVERT (...
IN clause in SQL Server
With IN clause, we can specify multiple values in a WHERE clause. For example, in case of “IN”, one can use the subquery to get...
While loop in SQL server
While loop in SQL server Introduction In While loop, we set a condition for the repeated execution of a Code block. So we use while...
Case Statement/ Expression in SQL Server
Case Statement/ Expression in SQL server Sometimes we need to get one result output from multiple possible outcomes based on the evaluation of some expression....
Boyce – Codd Normal Form (BCNF)
Boyce – Codd Normal Form (BCNF) :- A normal form is said to be a Boyce – Codd Normal Form if it is in 3NF and...
Adding , Deleting and Updating a Column in a table
Many times we need to alter the table definition by adding , deleting or updating a column in the table. In this article, I am...
SQL Server-Table Variable
Table variable:- SQL Server provides an variable known as table variable which is used to store data in a similar way as we store data in physical tables...
SQL Server – Local temporary table
Local temporary table:- Local temporary table is created in the tempdb and it is visible to the current user’s session only. It remains exists till...
SQL Server – Global temporary tables
Global temporary table:- Global temporary table is created in the tempdb and it is visible to all other sessions as well. Global temporary tables are only destroyed...