why with(NOlock) is used in sql query code example Example: SQL nolock SELECT * FROM LockTestDemo WITH (NOLOCK)