ADO.NET Programming with CDR (Wordware programming library)
Appendix C: Views, Stored Procedures, and Triggers
- Listing C-1 The “Alphabetical list of products” view
- Listing C-2 Order Header Query view
- Listing C-3 ABC Sales by Customer query
- Listing C-4 Top 10 Customers and Bottom 10 Customers view
- Listing C-5 The new ABC Sales by Customer query
- Listing C-6 sp_SubTotal
- Listing C-7 Check Product Order Details trigger
Appendix D: Advanced SQL Query Techniques
- Listing D-1
- Listing D-2
- Listing D-3
- Listing D-4
- Listing D-5
- Listing D-6
- Listing D-7
- Listing D-8a
- Listing D-8b
- Listing D-8c
- Listing D-8d
- Listing D-8e
- Listing D-9a
- Listing D-9b
- Listing D-9c
- Listing D-10
- Listing D-11
- Listing D-12a
- Listing D-12b
- Listing D-12c
- Listing D-12d
- Listing D-12e
- Listing D-13a
- Listing D-13b
- Listing D-14a
- Listing D-14b
- Listing D-15a
- Listing D-15b
- Listing D-16a
- Listing D-16b
- Listing D-16c