>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