T-Sql触发器（trigger）(二)
ney;
10 declare @datetime datetime;
11 select @price1=ProductPrice from deleted;
12 select @price2=ProductPrice from inserted;
13 if @price1!=@price2
14 begin
15 declare @ProductID int;
16 select @ProductID=ProductID from inserted
17 insert into Logs(ID,operatedatetime,ProductID,oldprice,newprice)
18 values(newid(),convert(datetime,getdate()),@ProductID,@price1,@price2)
19
20 select *from dbo.Logs
21 end
22 end
23 else if exists(select *from inserted)
24 begin
25 print('insert');
26 end
27 else if exists(select *from deleted)
28 begin
29 print('delete');
30 end
31 else
32 begin
33 print('others');
34 end
35 end