read table no lock sql server code example Example: SQL nolock SELECT * FROM LockTestDemo WITH (NOLOCK)