embedded SQL

SQL statements that are written into a high-level programming language such as C or Pascal. In a preprocessing stage, the SQL code is converted into function calls, which may be optimized to provide the fastest results. If the programmer knows exactly what the query is going to do, and the query does not change, it is called "static SQL." If the query requires user input at runtime, it is called "dynamic SQL." If the client program passes the SQL statements directly to the database server without any intermediate step, it is called "passthrough SQL."

Copyright © 1981-2025 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.

Mentioned in

References in periodicals archive

<% DIM connString, conn ConnString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=www3.north.londonmet.ac.uk; PORT=3307; DATABASE=dbname; UID=userid; PASSWORD=userpw; OPTION=3" SET conn = Server.CreateObject("ADODB.Connection") conn.Open(connString) SET rs = Server.CreateObject("ADODB.recordset") rs.open "SELECT * FROM table_name", conn %> The embedded SQL query, SELECT * FROM table_name, was to select every filed from the table_name table of the dbname MySQL database.

Performance of database driven network applications from the user perspective

A developer is able to quickly define and generate Web services and take advantage of embedded SQL, Single Sign On (SSO) Security and hierarchical data structures.

Unify announces NXJ Developer

The unit uses a high-speed embedded SQL database for storing information, enabling full-featured searches based on alarms, camera name, date, and time.

Network video recorder

Consequently, incorporating a hands-on exposure to such front-ends, as well as embedded SQL, in the course will enhance the overall value of the course to the students.

Real-life experiences in computing courses

All content on this website, including dictionary, thesaurus, literature, geography, and other reference data is for informational purposes only. This information should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional.