-
Notifications
You must be signed in to change notification settings - Fork 0
/
Triggers.sql
42 lines (28 loc) · 983 Bytes
/
Triggers.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
use shoppingstoreDB
--TRIGGERS
--add order
--@kacadet = howmany
--@hangiurunId = whichproductId
create trigger trg_InserOrder on orderdetails
After Insert
as
Declare @kacAdet int, @hangiUrunId int
select @hangiUrunId = ProductID, @kacAdet = Quantity from inserted
Update Products
SET UnitsInStock = UnitsInStock - @kacAdet
where ProductID = @hangiUrunId
--We entered 50 orders from the product with a product ID of 7
insert orderdetails (ProductID, Quantity, OrderID, UnitPrice,createdate) values (7, 50, 7, 20,getdate())
select * from Products where ProductID = 7
--deleted order
create trigger trg_orderdelete on orderdetails
after delete
as
Begin
declare @kacAdet int, @hangiUrun int;
select @hangiUrun = ProductID, @kacAdet = Quantity from deleted
Update Products
Set UnitsInStock = UnitsInStock + @kacAdet
where ProductID = @hangiUrun
End
delete from orderdetails where OrderID = 5 and ProductID = 9