Manually deciding locking mode in MSSQL
Sure, there are plenty of table hints, like:


PAGLOCK
ROWLOCK
TABLOCK
TABLOCKX


However, you should use these with extreme caution. There are very few cases where the average programmer knows better than the engine, and forcing hints can cause more problems than they solve.