Publisher's Synopsis
Learn about the SQL/PSM standard from the author of Understanding the New SQL Written by a leading contributor to the development of the SQL standard, Understanding SQL Stored Procedures introduces readers to the concepts of SQL stored procedures and how they are implemented in a variety of DBMSs. The author also teaches how to best apply the powerful storage features of PSM-96, which allow you to store SQL code in a database and execute it directly within the DBMS. Using practical and interesting examples to illustrate the power of stored procedures, Understanding SQL Stored Procedures offers readers complete coverage of the language's features as well as practical advice on how to best take advantage of them in database application programming. A final section is devoted to a discussion of the next generation of SQL/PSM.;Features: Complete, practical coverage of all the features of the SQL/PSM standard in an easy-to-find format (allows use as a reference) Supplements syntax of language elements with "railroad diagrams" to better illustrate how the elements of this language work together Utilizes a real-life application as a running example of the language features Written for database product and tool developers, application programmers, and database administrators and analysts, Understanding SQL Stored Procedures will help users better apply SQL/PSM.
