Understanding how locks are handled in the database is very important. The basics of the locking mechanism in MySQL and MS SQL Server are similar, but there are differences in the implementation.
MySQL uses read and write locks, and lock requests when it cannot establish a lock. The locks can be granted on row or table level, but row locking is available only for InnoDB engine.
In MS SQL Server the two main type of locks are also read and write locks, but resource handling is more complex.
This is the full list of lock types in SQL Server: