Prevent dirty reads
You have to analyze how many accounts have more than $50,000.
As the number of accounts is an important result, you don't want to read data modified by other transactions that haven't committed or rolled back yet. In doing this, you prevent dirty reads. However, you don't need to consider having non-repeatable or phantom reads.
Prepare the script.
Diese Übung ist Teil des Kurses
Transactions and Error Handling in SQL Server
Anleitung zur Übung
- Set the appropriate isolation level to prevent dirty reads.
- Select the count of accounts that match the criteria.
Interaktive Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
-- Set the appropriate isolation level
SET TRANSACTION ___ ___ ___ ___
-- Count the accounts
SELECT ___(*) AS number_of_accounts
FROM accounts
WHERE current_balance >= 50000;