SQL/Server 2000 & with(nolock) keyword
843854Dec 3 2004 — edited Dec 9 2004I 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?