Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>Your BEGIN TRANSACTION/END TRANSACTION has no effect for SQL Server and should not be used.
>
>What is the exact purpose of your code? Can you tell in English what are you trying to achieve? I think you can perform all operations as one long command rather than doing 3 separate SQL commands.
>
Dear Naomi Nosonovsky
According to my knowledge, BEGIN TRANSACTION/END TRANSACTION is a set of codes which passes commands. It works like electrical switch ON or OFF. If TRANSACTION is completed then all commands in BEGIN TRANSACTION/END TRANSACTION works others wise fail or rollback.
If connection fails with server during BEGIN TRANSACTION/END TRANSACTION then all is rollback like Insert,delete etc.
So I use code like this
BEGIN TRANSACTION
Delete voucher
Insert voucher
END TRANSACTION
If I do not use BEGIN TRANSACTION/END TRANSACTION and powere goes after DELETE VOUCHER then Insert commad will not run.
In case of useing BEGIN TRANSACTION/END TRANSACTION, powers goes on connection fails then all will be rollback.
May be my knowledge about BEGIN TRANSACTION/END TRANSACTION is wrong. If yes then please help how to modify my codes in a better way.
Thanks in advacne
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