On 8/7/22 00:30, Frank Millman wrote:
> Hi all
>
> Apologies if this is an FAQ, but I could not find the answer I was looking
> for.
>
> I want to run two SELECTs, one immediately after the other.
>
> I want to ensure that no other process updates the database in between the
> two.
>
> What is the best way to achieve this?
You probably want to put the queries in a Repeatable Read transaction, or
even a READ ONLY serialized transaction.
https://stream.boxwatch.ru/docs/12/transaction-iso.html#XACT-REPEATABLE-READ
https://stream.boxwatch.ru/docs/12/transaction-iso.html#XACT-SERIALIZABLE
https://stream.boxwatch.ru/docs/12/sql-set-transaction.html
--
Angular momentum makes the world go 'round.