Alan Freedman -- The Computer Language Company - Computer Desktop Encyclopedia
Computer Desktop Encyclopedia
Longest-Running Tech Reference on the Planet

A CDE Definition

You'll love The Computer Desktop Encyclopedia (CDE) for Tech Term of the Day (TTOD)

LOOK UP ANOTHER TERM


SQL based

Software that uses the SQL language to communicate with a database. See SQL.



SQL

(Structured Query Language) Pronounced "S-Q-L" or "see-quill," a language used to interrogate and process data in a relational database. Originally developed by IBM for its mainframes, SQL commands can be used to interactively work with a database or can be embedded within a script or programming language to interface to a database. Programming extensions to SQL have turned it into a full-blown database programming language, and all major database management systems (DBMSs) support it.

ANSI standardized SQL, but most DBMSs have some proprietary enhancement, which if used, makes SQL non-standard. Moving an application from one SQL database to another sometimes requires tweaking, the age old problem in this business! See MySQL, MDX, CLI, ODBC, IDAPI and SQL injection.

The following SQL query selects customers with credit limits of at least $5,000 and puts them into sequence from highest credit limit to lowest. The blue words are SQL verbs. See SPUFI.


     select name, city, state, zipcode
     from customer
     where creditlimit > 4999
     order by creditlimit desc





From Natural Language to SQL
English Wizard generated the SQL code at the bottom from the English sentence at the top. A lot of SQL code is required to ask a simple question. (Screen shot courtesy of EasyAsk Inc.)






Personal Use Only

Before/After Your Search Term
BeforeAfter
spycamSQL/DS
spywareSQL engine
spyware blockerSQL Forms
spyware removerSQL injection
SQSQL insertion
SQ1SQL Lite
SQ2SQL precompiler
SQASQL Server
SQFPSQL Windows
SQLSQL*Forms

Terms By Topic
Click any of the following categories for a list of fundamental terms.
Computer Words You Gotta KnowSystem design
Job categoriesUnix/Linux
Interesting stuffPersonal computers
InternetIndustrial Automation/Process Control
Communications & networkingAssociations/Standards organizations
HistoryDesktop publishing
Audio/VideoGraphics
MainframesSecurity
ProgrammingHealthcare IT
System design