SELECT * FROM table1 WITH(NOLOCK) LEFT JOIN table2 WITH(NOLOCK) ON table1.ID=table2.ID On Tuesday, August 10, 2021 at 3:41:35 PM UTC-4 Jeremy Evans wrote:
> 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/0f9c5f53-074e-45ff-8158-2891a4a0fbe2n%40googlegroups.com.
