Views are Virtual Tables. Views cannot store data rather they only refer to data present in tables. View is […]

Advantages and Disadvantages of Views

Advantages of views 1)Security Each user can be given permission to access the database only through a small […]

CONCAT function in SQL

CONCAT function in SQL is supported in SQL 2012 + and not in older version. Use “+” to concatenate […]

Common Table Expressions (CTE)

Common table expression is abbreviated as CTE. It is a temporary named result set that you can reference […]

Types of locks in SQL Server

Types of locks in sql server are explained below. Intent Lock The intent lock shows the future intention […]