with nolock in sql server select code example Example: SQL nolock SELECT * FROM LockTestDemo WITH (NOLOCK)