SQL SERVER – Data types
Data types in SQL Server In relational database, we store data in tabular form where data is divided into columns.…
SQL Server – Convert() function
Convert () function in SQL Server Convert () function is used to convert an expression from one data type to…
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…
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…
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…
Boyce – Codd Normal Form (BCNF)
Boyce – Codd Normal Form (BCNF) :- A normal form is said to be a Boyce – Codd Normal Form…
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.…
SQL Server-Table Variable
Table variable:- SQL Server provides an variable known as table variable which is used to store data in a similar…
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…
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…