Transaction.sql

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

BEGIN TRANSACTION;
UPDATE dbo.E_9_Type_cargo 
SET TransportCost1Ton -= 500
WHERE NameCargo = 'alcohol'
        IF (@@error <> 0) -- Îòìåíèòü òðàíçàêöèþ, åñëè åñòü îøèáêè 
        ROLLBACK
SELECT 'Òðàíçàêöèÿ' AS "Ñîñòîÿíèå", 
          NameCargo AS "Íàèìåíîâàíèå ãðóçà", 
         TransportCost1Ton AS "Ñòîèìîñòü òðàíñïîðòèðîâêè 1 òîííû",
@@SPID AS "Ïðîöåññ",
@@TRANCOUNT AS "Êîëè÷åñòâî òðàíçàêöèé" 
FROM dbo.E_9_Type_cargo WHERE NameCargo='alcohol';

UPDATE dbo.E_9_Type_cargo
SET TransportCost1Ton += 500
WHERE NameCargo = 'acid';
        IF (@@error <> 0) -- Îòìåíèòü òðàíçàêöèþ, åñëè åñòü îøèáêè 
        ROLLBACK
COMMIT TRANSACTION; -- Çàâåðøåíèå òðàíçàêöèè
SELECT 'Ïîñëå òðàíçàêöèè' AS "Ñîñòîÿíèå", 
         NameCargo AS "Íàèìåíîâàíèå ãðóçà", 
         TransportCost1Ton AS "Ñòîèìîñòü òðàíñïîðòèðîâêè 1 òîííû",
@@SPID AS "Ïðîöåññ",
@@TRANCOUNT AS "Êîëè÷åñòâî òðàíçàêöèé"
FROM dbo.E_9_Type_cargo WHERE NameCargo = 'acid';