sql
48 ResultsDictionary
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...
Dictionary
Definition: 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, 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
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.)
THIS DEFINITION IS FOR PERSONAL USE ONLY
All other reproduction is strictly prohibited without permission from the publisher.
© 1981-2010 The Computer Language Company Inc. All rights reserved.
Sponsored White Papers, Webcasts & Resources
-
Automating Infrastructure and Operations Management with VMware
With VMware, virtualization tools come with a management system built in. Check out this webcast to learn more.
-
Multitenancy & Cloud Computing Platforms: Four Big Problems
We take a break from our regularly scheduled mobile blog to rant about the buzzword multitenancy, and why it may actually be bad for enterprise ISVs.
-
Microsoft delivers service for integrating social Web data into business apps
Project "Vancouver," Microsoft's new cloud-based social-analytics service, is available to testers interested in the idea of integrating social Web data into business applications.
-
Over a million web sites affected in mass SQL injection attack
Security researchers from Armorize have intercepted a mass SQL injection attack, targeting ASP ASP.NET websites.
-
Microsoft Office 365 and SQL Azure updates: What's on tap
Microsoft is set to begin rolling out new updates to its Office 365, SQL Azure and Dynamics CRM Online services in the coming weeks/months.
-
Microsoft and Oracle part ways over multitenancy in the cloud
Microsoft and Oracle are on opposite sides when it comes to the importance of multitenancy support to their respective public-cloud platforms.
-
-
Mass SQL injection attack leads to scareware
Security researchers from WebSense have detected a mass SQL injection attack, which the cybercriminals monetize through scareware, also known as fake security software.
-
Microsoft readies public SQL Azure Reporting test build, as Salesforce launches a cloud database
Microsoft began taking sign ups for its SQL Azure Reporting Services public test build on the same day that rival Salesforce unveiled its plans for a cloud database of its own.
-
Microsoft delivers MySQL-to-SQL database migration tool
On August 12, Microsoft made available the first version of a tool designed to help customers migrate from MySQL to SQL Server and/or SQL Azure.
-
Another piece of Microsoft's Oslo modeling puzzle disappears
Microsoft is dropping Quadrant, a tool originally slated to be part its data-modeling platform, which was originally codenamed Oslo, and is revising its plans for its M data-modeling language.
-
The Pirate Bay hacked through multiple SQL injections
By using multiple SQL injections, Argentinian group of security researchers managed to obtain access to the Pirate Bay's administration panel, leading to the exposure of sensitive data belonging...
-
Aster Data delivers 30 analytic packages and MapReduce functions for mainstream data analytics
The solution is a massively parallel database with an integrated analytics engine that leverages the MapReduce framework for large-scale data processing and couples SQL with MapReduce.
-
Researchers find 12 zero day flaws, targeting 5 web malware exploitation kits
Security researchers from TEHTRI-Security, have found 12 zero day flaws targeting 5 of the most common web malware exploitation kits such as Neon, Eleonore, Liberty, Lucky and the Yes...
-
Microsoft tweaks its cloud database pricing
Microsoft made a raft of cloud-related announcements at its TechEd conference last week. But one of them got relatively little notice: Changes to the company's SQL Azure cloud database pricing.
-
Microsoft: Enterprise customer growth accelerates private cloud strategy
Microsoft is making a number of announcements around tools and database tweaks for its Azure cloud platform at this week's TechEd conference. But I'm more interested in some of the more subtle...
-
Microsoft to provide customers with more cloud storage
Microsoft made a couple of somewhat under-the-radar cloud-storage announcements this past week -- one involving SQL Azure and the other regarding Exchange Online.
-
Microsoft Windows Azure and SQL Azure
Microsoft's Windows Azure and SQL Azure address part of organizations requirements for an open, standards based platform that can support local, private and public clouds.
-
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.
-
phpMyAdmin Plugs SQL Injection, XSS Flaws
A new version of phpMyAdmin has been released to plug two serious security holes that could lead to SQL injection and cross-site scripting attacks.
-
Microsoft rolls out a refreshed Security Essentials, new SQL test builds and more
Microsoft has rolled out a number of new test and final builds of all kinds of products in the past day or two. Rather than do individual posts on each, I'm providing a few pointers where you can...
-
Gonzales just tip of iceberg in Heartland attack
Albert Gonzales, previously accused of breaking into TJX's computer systems, was indicted on charges that a separate group he was involved in breached Heartland Payment Systems. Also indicted...
The best of ZDNet, delivered
ZDNet Newsletters
Get the best of ZDNet delivered straight to your inbox
Vendor Showcase
