Sams Teach Yourself SQL in 21 Days, Fourth Edition

Using Embedded SQL

This book uses the term embedded SQL to refer to the larger topic of writing actual program code using SQL—that is, writing stored procedures embedded in the database that can be called by an application program to perform some task. Some database systems come with complete toolkits that enable you to build simple screens and menu objects using a combination of a proprietary programming language and SQL. The SQL code is embedded within this code.

On the other hand, embedded SQL commonly refers to what is technically known as Static SQL.

Static and Dynamic SQL

Static SQL means embedding SQL statements directly within programming code. This code cannot be modified at runtime. In fact, most implementations of Static SQL require ...