Support lock hints in SQLServer on SELECT, UPDATE and DELETE.
MSSQL accepts plenty of locking hints in SELECT, UPDATE and DELETE.
It can be NOLOCK, ROWLOCK, TABLOCK, and plenty of others.
If a lock is passed, it will be applied to every table (being the main one
or a join table).