United Business Media EE Times


Search

HOMEMARKET INTELLIGENCE UNITFORUMSDESIGNNEW PRODUCTSCAREERSBLOGSCONTACTEVENTSSIGN UP!RSSMost Popular contentTrusted Sources

 

Encyclopedia

Results found for: 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, all database systems designed for client/server environments support SQL. SQL commands can be used to interactively work with a database or can be embedded within a 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 the language.

     ANSI standardized SQL, but most database management systems (DBMSs) have some proprietary enhancement, which if used, makes SQL non standard. Moving an application from one SQL database to another may require tailoring to convert some commands. The age old dilemma in this business! See MDX, CLI, ODBC and IDAPI.

     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





Natural Language and SQL
EasyAsk's English Wizard generated the SQL code in the window at the bottom from the English sentence at the top. It is amazing how much SQL is necessary to ask what looks like a simple question. (Screen shot courtesy of EasyAsk Inc.)





similar terms
Entries before SQL
spyware remover
SQ
SQ1
SQ2
SQFP
Entries after SQL
SQL/DS
SQL engine
SQL Forms
SQL precompiler
SQL Server
 




Or get a random definition
techweb
copyright THIS COPYRIGHTED DEFINITION IS FOR PERSONAL USE ONLY.
All other reproduction is strictly prohibited without permission from the publisher.

Copyright (©) 1981-2007 The Computer Language Company
Inc All rights reserved.

  Free Subscription to EE Times
First Name Last Name
Company Name Title
Email address
  Click here for your Free Subscription to EETimes Europe

 
CAREER CENTER
Looking for a new job?
SEARCH JOBS
SPONSOR

RECENT JOB POSTINGS
CAREER NEWS
SRC Expands R&D Centers
The Semiconductor Research Corp has added a new center to its university R&D efforts.

For more great jobs, career related news, features and services, please visit EETimes' Career Center.


All White Papers »   

 
Education and
Learning


Learn Now:












Home | About | Editorial Calendar | Feedback | Subscriptions | Newsletter | Media Kit | Contact | Reprints|  RSS|   Digital|  Mobile
Network Websites
International
Network Features




All materials on this site Copyright © 2009 TechInsights, a Division of United Business Media LLC All rights reserved.
Privacy Statement | Terms of Service | About