Join GitHub today
GitHub is home to over 28 million developers working together to host and review code, manage projects, and build software together.Sign up
Table hint in SqlSubQuery #189
We are constructing a query and we need to put a table hint in a subquery of SQLServerQuery.
Our goal is the following Query:
from Table1 cr with (NOLOCK)
Trying to generate this query we wrote the following code:
SQLTemplates dialect = new SQLServerTemplates();
SQLServerQuery sqlServerQuery = new SQLServerQuery(getConnection(), dialect);
List<Object> rows = sqlServerQuery.from(t1).tableHints(SQLServerTableHints.NOLOCK)
We need to put the table hint ("with (NOLOCK)") in subquery, but today this is not possible.
Could you provide this functionality?
Thanks in advance,