(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-2008 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- Piecing together Microsoft's cloud-computing vision
- A new white paper, sponsored by Microsoft and written by the always entertaining consultant David Chappell, provides more clues about what the Softies are planning to unveil at this October's Professional Developers Conference. For anyone looking to understand how and where Red Dog, Zurich, BizTalk Services and SQL Server Data...
- Blog posts 2008-08-19
- My bad day with Windows Server 2003
- Today was not a good computer day. I had some good meetings (yes, actual good, productive meetings), finished a couple items on my to do list, and even got some of that good old Ikea furniture put together. The part of my job where I work with a...
- Blog posts 2008-08-18
- DEFCON 16: List of tools and stuff released
- Guest editorial by Rob Fuller DEFCON, the 9000+ attendee hacker conference in Vegas has become a sort of hydra conference. It has become more like a global fair than what most people think of conferences; even the badge is highly...
- Blog posts 2008-08-18
- The biggest open source threat to Microsoft
- The biggest open source threat to MicrosoftDid he.......no...False alarm. He didn't buy a Laptop. Never mind. ;)What makes it different from Wine then?or Mono for that matter? I had worked on Win-OS2, which is a Windows 3 inside OS/2, during OS/2's heydays. It failed miserably even with IBM's...
- Discussion threads 2008-08-15
- Friday Rant: Hey Microsoft! How about some more dialog about Vista before moving on to Windows 7?
- Friday Rant: Hey Microsoft! How about some more dialog about Vista before moving on to Windows 7?Friday Rant: Hey Microsoft! How about some more dialog about Vista before mWTF is up with ZDNet now? Ever since the site redesign the site has gone to hell with one whole "Microosft is...
- Discussion threads 2008-08-15
- 10+ reasons to use Access (and a few reasons not to)
- Microsoft Access may not be the king of databases, but it does offer a number of advantages over solutions like SQL Server and Oracle in certain situations. Access guru Susan Harkins counts the ways.This download is also available as an entry in our 10 Things blog.
- Download resources 2008-08-15
- Joomla hit by critical password-reset forgery flaw
- Joomla hit by critical password-reset forgery flawReset Yur Admin PasswordHere's a link to how to reset your password in MySQL if you have already been exploited. It's important that you do this if you are having issues.http://anotherguy.us/categories/software/25-recover-your-admin-password-in-joomlaWOW!All I can say is WOW! This is security 101, or even before that....
- Discussion threads 2008-08-13
- The Unix sysadmin salary premium
- The Unix sysadmin salary premiumThe non-obviously conclusions I draw...The non-obviously conclusions I draw from this is that organisations looking fron Windows admins could do well by bring in guys with Unix experience.(I can hear someone say "No self respecting unix guy would take the job", to which the answer is...
- Discussion threads 2008-08-13
- TxtToSql (exe)
- TxtToSql is a tool to import text CSV file data to SQL Server. Main features: Import text CSV file data into SQL Server Table. Run SQL command, see importing results. Support export textntext and image field. This version is the first release on CNET Download.com.
- Software downloads 2008-08-13
- Tcp Data Collector (exe)
- Resident program that runs in the system tray collecting data from six client channels. Each channel can be directed serially or to a remote site. Each tcp stream reports to the main console report center. Report is updated periodically to a daily report file. SQL Database is updated on each...
- Software downloads 2008-08-13
- Import Table from Excel for SQL Server (exe)
- Import Table for Microsoft SQL Server helps to load data from Excel spreadsheet. The program has easy to use wizard interface. All modern versions of Microsoft SQL Server and all versions of Microsoft Excel are supported. A few options make import process more flexible and comfortable. This handy utility helps...
- Software downloads 2008-08-13
- Export Database to Excel for SQL Server (exe)
- Export Database to Excel for SQL Server helps to save tables to Excel spreadsheets. Export options make export process more flexible. The program has easy to use wizard interface. The program has easy to use wizard interface. This handy utility helps users, database developers and database administrators to create table-based...
- Software downloads 2008-08-13
- Export Database to SQL for SQL Server (exe)
- Export Database to SQL for Microsoft SQL Server helps to save table's data as a set of insert SQL statements and optional create table statement. Predefined or cusrtom separators like 'go', two identity support modes and a few options make this tool flexible. The program has easy to learn and...
- Software downloads 2008-08-13
- DBComparer (exe)
- DBComparer is a professional database tool for comparing Microsoft SQL Server 2005 database structure. It is a tool for any project development team or DBA's managing multiple copies of the same database on SQL Server. It's uniquely build user interface will bring you the best visual representation of differences and...
- Software downloads 2008-08-12
- Microsoft to deliver SQL Server 2008 in August
- Microsoft to deliver SQL Server 2008 in AugustSQL Injection Immunization; finally available!We've developed a SQL Injection Cleaning process that scans, cleans and [i]permanently immunizes[/i] SQL Servers; including the more sophisticated ASCII injections.It's gotten the attention of the folks at Redmond, as it provides protection in areas MS weren't convinced could...
- Discussion threads 2008-08-11
- Coordinated Russia vs Georgia cyber attack in progress
- In the wake of the Russian-Georgian conflict, a week worth of speculations around Russian Internet forums have finally materialized into a coordinated cyber attack against Georgia's Internet infrastructure. The attacks have already managed to compromise several government web sites, with continuing DDoS attacks against numerous other Georgian government sites, prompting...
- Blog posts 2008-08-11
- InterLinx Online Backup Manager (exe)
- InterLinx Online Backup Manager is a multi-platform data backup solution that integrates into our high security Internet data centre to provide top-quality off-site data backup for your PC or server. The software will backup all your files, Outlook E-mail and desktop settings. On your server the software will backup all...
- Software downloads 2008-08-11
- Live Webcast: Dell EqualLogic PS Series Demonstration for SQL Server Protection and Rapid Recovery
- Join Dell EqualLogic for a demonstration of the PS Series with Smart Copy functionality, designed to deliver comprehensive SQL Server database protection, rapid recovery and high availability.
- Webcasts 2008-08-08
- Text to SQL Converter (msi)
- The converter creates a set of INSERTS based on text file delimited or fixed width. It is ideally tool to prepare data import to inaccessible database or to system that does not support direct data import. The program supports: predefined or custom column separators, predefined or custom SQL statement separators,...
- Software downloads 2008-08-08
- Navicat MySQL Manager for Mac OS X - Compatible with Mac OS X Leopard (dmg)
- Navicat is a professional and intuitive database management tool lets you create, browse databases and run SQL queries in an easier way. This MySQL Client tool features an intuitive interface and provides a set of useful tool to manage, backup/ restore, import/ export data, Synchronize database and connect to remote...
- Software downloads 2008-08-08
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- Which solar technology will survive?
-
At the Cleantech Forum in San Francisco, Todd Glass of Heller Ehrman moderates a discussion, among tech execs, on the various solar technologies making a difference in the green movement.
- Watch the video >>
- Access the latest Intel and industry best practices
-
Designed specifically to address the concerns of senior IT managers at organizations with more than 100 employees, the Intel Premier IT Professional Program provides best practices via local and e-Seminars and a members-only Web site.
- View the Intel Premier IT Professional web-site tour >>
