-
NOLOCK usage
I understand that using the NOLOCK in a select statement will help with table locking in SQLServer 7, but when I try to use it the server reports that it isn't in the right spot -- I checked the BOL and I believe I'm using it correctly.
Can nolock be applied to updates and inserts too? And what's the best way to use it?
My usage:
SELECT * FROM myTable(NOLOCK) ...
Thanks from a newbie,
John
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|