Lock Modes in SQL Server Part 2

Lock Modes in SQL Server ensures the concurrency and data integrity for multiple users. This is essential because we want all users to be able to use the database without any delays. Every thing to know about Levels of Locking in SQL Server read below link Read More : Locking in SQL Server Part 1  … Continue reading Lock Modes in SQL Server Part 2

SQL View Create Alter & Drop

SQL VIEW is very useful database object .  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 SQL queries practice . You can use our Sample College Database script & … Continue reading SQL View Create Alter & Drop