On Tue, Aug 10, 2021 at 12:32 PM Paul <[email protected]> wrote: > Using the dataset .nolock function seems to work on the main query > table...however, if you join other tables, I don't see any way to apply > WITH(NOLOCK) to the joined tables. How to do that? > > (And yes, in MSSQL you do need to explicitly apply WITH(NOLOCK) to every > joined table if you're looking for fully dirty reads.) >
Can you please give an example of the SQL that you want to produce? Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/CADGZSSewdu3qkVmg8apBj%3DiKb6vZnKr4HANyV238_hSewyauww%40mail.gmail.com.
