Unformatted text preview: network traffic and increase performance because they are stored at the server and do not get transmitted from a terminal to the server. They also reduce code duplication by code isolation and code sharing minimizing the number of errors and reducing the cost of development and maintenance. For example, if you are using the same query over and over again, it would make sense to put it into a stored procedure. When you put this SQL statement in a stored procedure, you can then run the stored procedure from the database's command environment. Problems: Chapter 7: 19, 20 SELECT CUS_CODE, INV_NUMBER, P_DESCRIPT, LINE_UNITS AS UNITS BOUGHT, LINE_PRICE AS UNIT PRICE, LINE_UNITS*LINE_PRICE AS SUBTOTAL FROM INVOICE, LINE, PRODUCT...
View Full Document
This note was uploaded on 08/02/2009 for the course IST 210 taught by Professor Mcconn,charlotteryoo,jungwoo during the Summer '08 term at Penn State.
- Summer '08