Ky leksion 120 minutesh perfshin faqet 411 - 468 te librit te kursit.
Salle:
BEGIN TRANSACTION Dalje
update Production.Products set unitprice=unitprice-1 where unitprice=2
update Production.Products set unitprice=unitprice-1 where unitprice=0
IF (@@ERROR<>0)
BEGIN
ROLLBACK TRANSACTION Dalje
print 'Transaksioni i daljes deshtoi'
END
ELSE
BEGIN
COMMIT TRANSACTION Dalje
print 'Transaksini shkoi me sukses'
END
Ushtrime
1. Queryt e leksionit paraardhes te realizohen me ane te transaksioneve.