No. With(TABLOCK) specifies the granularity of the lock (Key,Page,Object) and not the lock mode(shared,exclusive,...) . if you update the table with using WITH(TABLOCK) hint SQL would put "X" lock on the table and other sessions would not be able to access the table. you can query sys.dm_tran_locks to confirm that.