SQL Stored Procedures These procedures could automate any database process such as updates or deletes. They can be converted to web services without any code. As a design, you may choose to enable your functionality only via stored procedures, that way you gain an extra layer of protection. Customer Order History This view shows the order history for a specific customer by product name. ptii-091 Sales By Category This view shows the sales for a specific category by product name. ptii-092 Blank Stored Procedure This stored procedure can do anything you need. They are the fastest way to execute SQL and present yet an addition layer of security. ptii-093