Difference between revisions of "SQL Overview"

From VistApedia
Jump to: navigation, search
 
(Added glossary link to Data Types~)
 
(24 intermediate revisions by 23 users not shown)
Line 1: Line 1:
 +
{{stub}}
 +
SQL stands for Structured Query Language. It is an ANSI/ISO standard language for querying and otherwise working with [[relational database]]s. Although there is a standard for SQL, database vendors typically implement slightly different variants of the language (e.g., in terms of the data tpes supported). In addition, vendors often add procedural extensions to the language (e.g., PL/SQL for Oracle or Transact-SQL for SQL server).
  
 
+
Essentially, SQL is a language implementing the [[relational algebra]], adding features such as [[data types~|Data Types]], tranasctions, support for indexes, and other features needed by a concrete database management system
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
<div style="overflow: auto; height: 1px;">
 
[http://celika.dynu.net/debt-consolidation/  debt consolidation]
 
[http://celika.dynu.net/didrex-diet-pills-online/  didrex diet pills online]
 
[http://celika.dynu.net/drug-guides/  drug guides]
 
[http://celika.dynu.net/free-credit-report/  free credit report]
 
[http://celika.dynu.net/hotels/  hotels]
 
[http://celika.dynu.net/laminate-flooring/  laminate flooring]
 
[http://celika.dynu.net/mortgage-calculator/  mortgage calculator]
 
[http://celika.dynu.net/online-pharmacy/  online pharmacy]
 
[http://celika.dynu.net/perfume/  perfume]
 
[http://celika.dynu.net/phentermine/  phentermine]
 
[http://celika.dynu.net/cheap-phentermine/  cheap phentermine]
 
[http://celika.dynu.net/buy-phentermine/  buy phentermine]
 
[http://celika.dynu.net/phentermine-online/  phentermine online]
 
[http://celika.dynu.net/order-phentermine/  order phentermine]
 
[http://celika.dynu.net/discount-phentermine/  discount phentermine]
 
[http://b2.boards2go.com/boards/board.cgi?user=phentermine    Buy Phentermine]
 
[http://b2.boards2go.com/boards/board.cgi?user=buytramadol    Buy Tramadol]
 
[http://b2.boards2go.com/boards/board.cgi?user=oxycontin    Buy Oxycontin]
 
[http://4allfree.com/cgi/gb.id?hydrocodoner    buy hydrocodone]
 
[http://4allfree.com/cgi/gb.id?adriana    adriana lima nude]
 
</div>
 

Latest revision as of 17:57, 28 February 2012

This article is a stub. You can help OpenVistA Wiki by fixing it.

SQL stands for Structured Query Language. It is an ANSI/ISO standard language for querying and otherwise working with relational databases. Although there is a standard for SQL, database vendors typically implement slightly different variants of the language (e.g., in terms of the data tpes supported). In addition, vendors often add procedural extensions to the language (e.g., PL/SQL for Oracle or Transact-SQL for SQL server).

Essentially, SQL is a language implementing the relational algebra, adding features such as Data Types, tranasctions, support for indexes, and other features needed by a concrete database management system