EntLibQuickStarts数据库Products表里的两个触发器

Question

1. CREATE TRIGGER trInsert ON dbo.Products
2. FOR INSERT
3. AS
5. Update
6.   Products
7. Set
8.   LastUpdate = GetDate()
9. From
10.   Products p Inner Join Inserted i On p.ProductID = i.ProductID
11. Where
12.   p.ProductID = i.ProductID
14. GO
16. CREATE TRIGGER trUpdate ON dbo.Products
17. FOR UPDATE
18. AS
20. Update
21.   Products
22. Set
23.   LastUpdate = GetDate()
24. From
25.   Products p Inner Join Inserted i On p.ProductID = i.ProductID
26. Where
27.   p.ProductID = i.ProductID
29. GO

复制代码