Overview
Explains Structured Query Language (SQL) programming from the rudiments to subtleties that many experts may not know. The programmingexplanations are generic, explaining how best to interface withany SQL product that conforms to the ANSI standard.Key Topics
How to embed SQL in C. How to use an application programming interface(API) with Microsoft's Open Database Connectivity interface (ODBC)as the example API. Strategies for portable programs and highperformance. Thorough summaries of SQL commands. An appendix surveysSQL vendors, packages, standards organizations, books, and magazines.
Audience
This book is for data processing professionals converting to theC programming language and for pofessional database applicationdevelopers working in C who need in-depth information on how bestto interface their applications with a Structured Query Languagedatabase.
A practical guide for C programmers intended to clarify and explain embedded SQL in C, Open Database Connectivity (ODBC)/SQL API, and SQL performance optimization. Based on SQL92. Compares embedded static and dynamic SQL, uses complete code examples to analyze compiler behavior as a means of defining problem SQL statements. Overviews ODBC core functions (handshaking, action, error/warning, host variable, select) and some non-core functions. This section has a complete ODBC program listing with a lot of helpful comments. Discusses pros/cons of indexing and evaluates performance. Very good chapter on optimization with code examples in two columns, one slow, the other fast. Analyzes the code and clearly explains why seemingly trivial changes in SQL statements bring big benefits. Disk contains text programs, sample database libraries and an embeded SQL precompiler.