Locking in SQL Server

Locking in SQL Server is mechanism to control and manage concurrency maintaining data integrity and validation. This allows multiple users to access  and use database concurrently. Consider the scenario and let me paint the complete picture here. When we talk about concurrency in DBMS ,...
Continue reading »

What Is View In SQL

In SQL one of the very useful database object is View.  We will learn SQL CREATE VIEW , ALTER VIEW & DROP VIEW Statements today with the conceptual understanding of it as well. Now , If you have our College database you can do basic...
Continue reading »