SQL transaktsioonid ülesanne

START TRANSACTION
INSERT INTO developers(NAME,SPECIALTY,EXPERIENCE,SALARY)
VALUES('Eugene Suleimanov', 'Java', 2, 2500)
INSERT INTO developers(NAME,SPECIALTY,EXPERIENCE,SALARY)
VALUES('Peter Romanenko', 'Java', 3, 3500)
INSERT INTO developers(NAME,SPECIALTY,EXPERIENCE,SALARY)
VALUES('Andrei Komarov', 'C++', 3, 2500)
INSERT INTO developers(NAME,SPECIALTY,EXPERIENCE,SALARY)
VALUES('Konstantin Geiko', 'C#', 2, 2000)
INSERT INTO developers(NAME,SPECIALTY,EXPERIENCE,SALARY)
VALUES('Asya Suleimanova', 'UI/UX', 2, 1800)
INSERT INTO developers(NAME,SPECIALTY,EXPERIENCE,SALARY)
VALUES('Ivan Ivanov', 'C#', 1, 900)
INSERT INTO developers(NAME,SPECIALTY,EXPERIENCE,SALARY)
VALUES('Ludmila Geiko', 'UI/UX', 3, 1800)
COMMIT

Transaktsiooni loomine

Uurimine ROLLBACK

START TRANSACTION;
SAVEPOINT SP1;
SELECT * FROM developers;
DELETE FROM developers WHERE ID = 5;
DELETE FROM developers WHERE ID = 6;
DELETE FROM developers WHERE ID = 7;
SELECT * FROM developers;
ROLLBACK TO SP1;
SELECT * FROM developers;

Tehti transaktioon(START TRANSACTION) ja ilmus SAVEPOINT

Kirjed on kustutatud(DELETE)

Kirjed on tagasi lisatud(ROLLBACK)

Video Ülesanne

CREATE TABLE tblPhysicalAddress(
Addressid INT NOT NULL PRIMARY KEY identity(1,1),
EmployeeNumber INT,
HouseNumber char(10),
StreetAddress nvarchar(10),
City varchar(50),
PostalCode char(20))
CREATE TABLE tblMailingAddress(
Addressid INT NOT NULL PRIMARY KEY identity(1,1),
EmployeeNumber INT,
HouseNumber char(10),
StreetAddress nvarchar(10),
City varchar(50),
PostalCode char(20))
INSERT INTO tblPhysicalAddress(EmployeeNumber, HouseNumber, StreetAddress, City, PostalCode)
VALUES(101, '#10', 'King Street', 'LONDOON', 'CR27DW')
SELECT * FROM tblPhysicalAddress
INSERT INTO tblMailingAddress(EmployeeNumber, HouseNumber, StreetAddress, City, PostalCode)
VALUES(101, '#10', 'King Street', 'LONDOON', 'CR27DW')
SELECT * FROM tblMailingAddress

Cometted

Tegin protseduuri UPDATE koos transaktiooniga.

Siin on mõlemas tabelis LONDOONi linna VÄRSKENDUS LONDONI

esialgne tulemus

Kontrollib, kas kõik töötab

lõpptulemus

Rolled Back

Kontrollib, kas kõik töötab

lõpptulemus