SQL SERVER – Data types
Data types in SQL Server In relational database, we store data in tabular form where data is divided into columns.…
Data types in SQL Server In relational database, we store data in tabular form where data is divided into columns.…
Convert () function in SQL Server Convert () function is used to convert an expression from one data type to…
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 Introduction In While loop, we set a condition for the repeated execution of a Code…
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) :- A normal form is said to be a Boyce – Codd Normal Form…
Many times we need to alter the table definition by adding , deleting or updating a column in the table.…
Table variable:- SQL Server provides an variable known as table variable which is used to store data in a similar…
Local temporary table:- Local temporary table is created in the tempdb and it is visible to the current user’s session…
Global temporary table:- Global temporary table is created in the tempdb and it is visible to all other sessions as…