(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.
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.)
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.)
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2009 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- News to know: Windows 7; Google Dashboard; Driving while texting; Steve Jobs; Droid
- Here are today's notable headlines. You can get News To Know via email alert and RSS daily. For continuous updates see BNET's around-the-Web tech coverage.: Sam Diaz: Ballmer: So far, Windows 7 sales are "fantastic" Dana Blankenhorn: What the Google Privacy Dashboard can...
- Blog posts 2009-11-06
- Ballmer: So far, Windows 7 sales are "fantastic"
- RE: Ballmer: So far, Windows 7 sales are One report has at 4% market share the weekend of launch so im sure its past that already.Has Windows 7 marketshare eclipsed total OS X marketshare yet?Just wondering. :)MSFT: 1/2000 = $56. Today, $28.40Win 7 may not be the catastrophe the last...
- Discussion threads 2009-11-05
- Billing system testing behind Microsoft's SQL Azure outage this week
- Testers of Microsoft's SQL Azure service experienced a three-plus hour unplanned outage this week -- just a couple of weeks before Microsoft is set to remove the beta tag from its Azure cloud service. by Mary Jo Foley
- Blog posts 2009-11-05
- SQL Image Viewer 2.5.0.138 (Windows)
- SQL Image Viewer enables you to retrieve, view, convert, and export images stored in Firebird, MySQL, Oracle, SQLite, SQL Server and ODBC data sources, and supports the following image formats: BMP, GIF, JPG, PNG, PSD, and TIFF. It also recognises the following binary file types: PDF, MP3, WAV, 7Z, BZ2,...
- Software downloads 2009-11-05
- OpenLink Lite Edition ODBC Driver for SQL Server (TDS) 6.02.3280 (Mac)
- High-Performance ODBC Drivers provide transparent access to remote databases from any ODBC-compliant application. Desktop Productivity Tools (i.e., Spreadsheets, Word Processors, Presentation Packages, Desktop Databases, Personal Organizers, etc.), Client-Server Application Development Environments, Web-based Database Publishing Tools, and Computer Telephony Integration packages, are just a few of the many products that can...
- Software downloads 2009-11-05
- ProjectTrack SQL Server Edition 2007.9.0 (Windows)
- Planning is the beginning. ProjectTrack SQL Server Edition is an all-inclusive program that will help you execute your plan. Designed by and for project managers, ProjectTrack is a powerfully integrated management tool which keeps ALL information related to a project in one place. Keep track of Tasks, Action Items, Change...
- Software downloads 2009-11-05
- dbscript 0.99 (Windows)
- dbscript operates on database schema information imported from an MS SQL Server, Oracle or PostgreSQL database, or uploaded via SQL files containing Create statements, organizing the schema information in Project Versions. Based on this data, users can define Value Scripts, compare schemas, and generate schema documentation as MediaWiki and ScrewTurn...
- Software downloads 2009-11-05
- ESF Database Migration Toolkit Standard Edition 6.1.36 (Windows)
- The program transfers data across various database & file systems. It can directly connect to MySQL, SQL Server, PostgreSQL, Oracle, IBM DB2, FireBird/InterBase, Access, Excel, Visual Foxpro, SQLite, Paradox, Lotus, dBase, Text, and other formats, and transfer data (including Index, Primary Key, Foreign Key, BLOB, CLOB, and MEMO) between these...
- Software downloads 2009-11-05
- ESF Database Migration Toolkit Professional Edition 6.1.36 (Windows)
- ESF Database Migration Toolkit lets you transfer data across various database/file systems. With this toolkit, you can reduce the effort, cost, and risk of migrating to/from any of the following database/file systems: Oracle, MySQL, SQL Server, PostgreSQL, IBM DB2, Visual Foxpro, SQLite, FireBird, InterBase, Microsoft Access, Microsoft Excel, Paradox, Lotus,...
- Software downloads 2009-11-05
- News to know: AT&T, Verizon; T-Mobile; Microsoft CRM; Win7; datacenters; Sony-Ericcson
- Here are today's notable headlines. You can get News To Know via email alert and RSS daily. For continuous updates see BNET's around-the-Web tech coverage.: Sam Diaz: AT&T sues Verizon Wireless, calls map ad "misleading" but doesn't dispute accuracy Matthew Miller: T-Mobile experiences...
- Blog posts 2009-11-04
- Navicat Lite 8.2.16 (Windows)
- Navicat Lite is a multi-connections Database Administration tool allowing you to connect to MySQL, PostgreSQL and Oracle databases simultaneously within a single application, making database administration to multiple kinds of database so easy. Support of multi-connections to MySQL, PostgreSQL and Oracle servers. Support of transferring data between different servers. Support...
- Software downloads 2009-11-04
- Navicat Premium 8.2.16 (Windows)
- Navicat Premium is a multi-connections Database Administration tool allowing you to connect to MySQL, PostgreSQL and Oracle databases simultaneously within a single application, making database administration to multiple kinds of database so easy. Support of multi-connections to MySQL, PostgreSQL and Oracle servers. Support of transferring data between different servers. Support...
- Software downloads 2009-11-04
- Corner Bowl Log Manager 9.0.82 (Windows)
- Corner Bowl Log Manager is a network-wide Event Log, syslog and application log management tool that enables Systems Administrators to automate log monitoring, consolidation and archiving requirements set forth by management and regulatory agencies.Consolidate and archive logs to SQL Server, MySQL, a log appliance or a network location. Monitor logs...
- Software downloads 2009-11-04
- LogTen Pro 5.1.6 (Mac)
- LogTen Pro is a professional mac pilot logbook solution for pilots of all experience levels. Whether you're a CFI, operate a small charter, fly for a major airline, or just own your own plane, LogTen Pro will provide you with the tools to take control of your flight time. ...
- Software downloads 2009-11-04
- Microsoft to raise prices, add more high-end editions with SQL Server 2008 R2
- More likely to ship with Visual Studio 2010?Is it not more likley that SQL 2008 R2 will ship with Visual Studio 2010 as it has done with previous releases? I understand VS2010 is likely to be available in March (Mix 2010?). In this way, SQL is likely to be...
- Discussion threads 2009-11-03
- Microsoft to raise prices, add more high-end editions with SQL Server 2008 R2
- With the new version of its database due out by mid-2010, Microsoft is increasing its retail prices. It also is adding two new high-end editions of SQL Server 2008 R2 to its line-up. Other news from the opening day of Microsoft's SQL PASS conference: Microsoft is planning to make the...
- Blog posts 2009-11-03
- Database .NET 2.9.3594 (Windows)
- Database .NET is an intuitive database management tool for multi-database. It supports MS Access 97-2003/MS Access 2007/MS Excel 97-2003/MS Excel 2007/dBASE IV/Firebird/MySQL/SQL Server/SQL Server CE/SQLite/PostgreSQL/Oracle/OleDB databases. It allows to create, shrink, or protect databases automatically. Also features syntax highlighting, service manager, SQL example manager, multiple query tab, SQL query batch....
- Software downloads 2009-11-03
- Product Key Explorer 2.2.9 (Windows)
- Product Key Explorer displays product key for Windows, MS Office, SQL Server and over 800 other software products installed on your local or remote network computers. In order to install or reinstall Microsoft Office, Windows, or other commercial software, you must have access to a product serial key CD Key...
- Software downloads 2009-11-03
- SQLEditor 1.6b14 (Mac)
- SQLEditor is a tool that allows you to create SQL databases graphically. You can create and edit table structures. You can import and export designs to a JDBC compatible database, text files or save the designs as pdf images for the web or for print.See your databases rather than just...
- Software downloads 2009-11-03
- OraCmd 2.3 (Windows)
- OraCmd is a command-line tools working with Oracle directly through TCP/IP protocol and doesn't require Oracle client software. Main features: connect to Oracle without installing Oracle client software. Execute sql command. Run sql script from file. Load Oracle data from flat file (TXT, CSV). Unload Oracle data to flat file....
- Software downloads 2009-11-02
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
Meet Doc
-
-
Here to help you with your Document Management Needs
- Doc is an enigma. Born to a Russian ballerina and a German electrical engineer, he grew up in various locations in the United States. He’s seen the insides of more brands, versions, and generations of printer and printer-related hardware than almost anyone.
- To learn more about this mysterious figure check out his blog on ZDNet and his Workspace on TechRepublic. You’ll be glad you did.
-
Produced by
ZDNet and -
