1. --USE NORTHWND
2.  
3. --zad1
4. /*CREATE procedure OrderDates
5. @od data,
6. @do data
7. AS
8. Select * from Orders Where OrderDate >=@od
9. AND OrderDate<=@do
10.  
11. EXEC OrderDates '1996-07-01', '1996-07-10';
12. */
13.  
14. -- zad2
15.  
16. /*Create procedure zamowienia2
17. @wartosc int,
18. @countryText VARCHAR(15)
19. AS
20. Select *
21. From Customers
22. where country like @countryText AND @wartosc*/
23.  
24. --exec zamowienia2 10,'USA';
25.  
26. --zad3
27.  
28. /*create trigger drukuj on Products
29. after insert
30. as select *
31. from inserted*/
32.  
33. --zad4
34. /*create procedure Rabat2
35. @val int,
36. @disc_value float
37. AS
38. update [Order Details]
39. set Discount = @disc_value
40. where Quantity*UnitPrice>@val*/
41.  
42. --exec Rabat 1000, 0.4;
43.  
44. --zad5
45. /*alter table orders ADD LastModified date;
46. alter trigger trig2 on [Order Details] after insert, update, delete
47. as
48. update orders set LastModified = GETDATE() where OrderID in (select OrderID from inserted) or ...
49. insert into[Order Details](OrderID,ProductID) values(10248,41);
50. select orderID, LastModified from Orders where LastModified is not null;*/
51.  
52.  
53.  
54. --zad6
55.  
56. create trigger zad666
57. on customers
58. after insert
59.         as
60.         select *
61.         from products p
62.         join [Order Details]d
63.         on p.ProductID  = d.ProductID
64.         join orders o
65.         on o.OrderID = d.OrderID
66.         join customers c
67.         on o.CustomerID = c.CustomerID
68.  
69.  
70.  
71.  
72.  
73.  
74.  
75.  
76.