Mike Yearwood
Toronto, Ontario, Canada
Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2014
>That is a great example, one of the best I've seen for repeatable read. Thanks.
If I'm understanding this properly,
1 the user selects a record,
2 the record is stamped inside of a transaction - why is repeatable read needed?
3 the transaction ends
4 the user updates the record
5 the user saves the record.
If between 4 and 5 the user goes home ill, the record stays stamped. So there would have to be a way to un-stamp. Right?
How about this?
1 the user selects a record,
2 the transaction begins, the transaction rolls back if the user disconnects
3 the user edits the record
4 the user updates the record
5 the user saves the record.
6 the transaction ends
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement