brud tmp

SELECT * FROM Renewable_Energy_Devices WHERE device_id = 'Device_3';
-- Transakcja 1
BEGIN TRANSACTION;
UPDATE Renewable_Energy_Devices SET device_status = 1 WHERE device_id = 'Device_3';
-- Czekamy 3 sek.
-- WAITFOR DELAY '00:00:03';
SELECT * FROM Renewable_Energy_Devices WHERE device_id = 'Device_3';
-- Transakcja 2
BEGIN TRANSACTION;
UPDATE Renewable_Energy_Devices
SET device_status = 3
WHERE device_id = 'Device_3';
-- Zatwierdzenie zmian w transakcji 2
COMMIT TRANSACTION;
SELECT * FROM Renewable_Energy_Devices WHERE device_id = 'Device_3';
-- Zakończenie transakcji 1
COMMIT TRANSACTION;
SELECT * FROM Renewable_Energy_Devices WHERE device_id = 'Device_3';