what happens if we put with nolock in SQL code example Example: SQL nolock SELECT * FROM LockTestDemo WITH (NOLOCK)