Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Transaction Isolation
Message
De
18/08/2007 15:43:54
 
 
À
17/08/2007 16:41:19
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01248883
Message ID:
01248965
Vues:
23
Robin, Sergey answered your other question (about whether SQL SELECT statements outside a BEGIN TRANSACTION are affected by any SET ISOLATION commands), though I don't necessarily agree with his response about accounting reports.

Here's an easy way to test - open two SQL windows and issue queries and UPDATE statements against a single row in a table, and set your transaction levels accordingly. It's a quick and easy way to test behavior. Any SQL training class that covers isolation levels will use that technique.

Kevin
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform