Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL/Server 2000 & with(nolock) keyword

843854Dec 3 2004 — edited Dec 9 2004
I have tryed using SQL/Server 2000 Sp3 using Microsoft JDBC drivers Sp2 & Sp3:

select * from table with(nolock)

but this statement does not works.

I have an exception that says "Invalid sintax near keyword with"

The same statement using, for example, enterprise manager or query analizer
works correctly.
Any Idea?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 6 2005
Added on Dec 3 2004
2 comments
406 views