Web Listing 9: Sample DML Changes
--sample DML
update Sales.SpecialOffer set DiscountPct = 0.25
where SpecialOfferID = 2;
WAITFOR DELAY '00:01';
update Sales.SpecialOffer set DiscountPct = 0.35
where SpecialOfferID = 2;
WAITFOR DELAY '00:01';
update Sales.SpecialOffer set DiscountPct = 0.45
where SpecialOfferID = 2;
WAITFOR DELAY '00:01';
update Sales.SpecialOffer set DiscountPct = 0.55
where SpecialOfferID = 2;
WAITFOR DELAY '00:01';
update Sales.SpecialOffer set DiscountPct = 0.65
where SpecialOfferID = 2;
WAITFOR DELAY '00:01';
update Sales.SpecialOffer set DiscountPct = 0.75
where SpecialOfferID = 2;