how to select a table with no locks

• bp

  SSCarpal Tunnel

  Points: 4656

  More actions

  March 27, 2003 at 4:55 pm

  #106212

  I am trying to select a table without locking it. How come the following produces a syntax error?

  USE NORTHWIND

  SELECT EmployeeID FROM Employees WHERE EMPLOYEEID = 4 WITH (NOLOCK)

  Server: Msg 156, Level 15, State 1, Line 1

  Incorrect syntax near the keyword 'WITH'.

  Thanks in advance,

  Billy

• Cheddar

  SSC Eights!

  Points: 886

  More actions

  March 27, 2003 at 5:08 pm

  #452406

  Try it after the table name.

  USE NORTHWIND

  SELECT EmployeeID

  FROM Employees WITH (NOLOCK)

  WHERE EMPLOYEEID = 4