Where do I put the NOLOCK?

Thanks!


------------
colin Leversuch-Roberts at 12/8/99 6:50:27 AM

Consider using NOLOCK ( bearing in mind the implications of .. ) in your query
It's a technique that can minimise locking for complex reports.



------------
Andrew Wiegand at 12/7/99 10:24:19 PM

yes,
The query trying to update/insert records into the table must wait for the other query to finish before it can acquire the appropriate locks on the table.


------------
White Choco at 12/7/99 7:21:56 PM


Hello...

Is it normal in SQL Server 6.5 the user who only running the query blocking the other user who try to update/add the records?

note: The query is a complex SQL.

Many Thanks!