Difference between revisions of "SQL Overview"

From VistApedia
Jump to: navigation, search
(Added glossary link to Data Types~)
 
(10 intermediate revisions by 10 users not shown)
Line 1: Line 1:
SQL stands for Structured Query Language. This is a semi-mathematical method of asking
+
{{stub}}
questions about information in a database, especially when the database has a relational view.
+
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=&quot;overflow: auto; height: 1px;&quot;>
 
[http://xanaxxanax.3xforum.ro/ xanax]
 
[http://tramadol2006.3xforum.ro tramadol]
 
[http://viagraviagra.3xforum.ro viagra]
 
[http://buylevitra.3xforum.ro/ levitra]
 
[http://soma.3xforum.ro/ soma]
 
[http://meridiameridia.3xforum.ro/ meridia]
 
[http://adipexp.3xforum.ro/ adipex]
 
[http://valiumvalium.3xforum.ro/ valium]
 
[http://h1.ripway.com/hotinnet/buyxanax.htm buy xanax]
 
[http://h1.ripway.com/pokupka2006/buy-cheapest-phentermine.htm buy cheapest phentermine]
 
[http://h1.ripway.com/pokupka2006/buy-phentermine-in-canada.htm buy phentermine in Canada]
 
[http://h1.ripway.com/pokupka2006/cheapest-phentermine.htm cheapest phentermine]
 
[http://h1.ripway.com/pokupka2006/cheap-phentermine.htm cheap phentermine]
 
[http://h1.ripway.com/pokupka2006/discount-phentermine.htm discount phentermine]
 
[http://h1.ripway.com/pokupka2006/ phentermine]
 
[http://h1.ripway.com/pokupka2006/order-phentermine-online.htm order phentermine online]
 
[http://h1.ripway.com/pokupka2006/pay-pal-phentermine.htm pay pal phentermine]
 
[http://h1.ripway.com/pokupka2006/phentermine-375-mg.htm phentermine 375-mg]
 
[http://h1.ripway.com/pokupka2006/phentermine-adipex.htm phentermine adipex]
 
[http://h1.ripway.com/pokupka2006/phentermine-by-check.htm phentermine by check]
 
[http://h1.ripway.com/pokupka2006/phentermine-diet-pill.htm phentermine diet pill]
 
[http://h1.ripway.com/pokupka2006/phentermine-free-shipping.htm phentermine free shipping]
 
[http://h1.ripway.com/pokupka2006/phentermine-online-pharmacy.htm phentermine online pharmacy]
 
[http://h1.ripway.com/pokupka2006/phentermine-prescription.htm phentermine prescription]
 
[http://h1.ripway.com/pokupka2006/phentermine-purchase.htm phentermine purchase]
 
[http://h1.ripway.com/pokupka2006/phentermine-united-kingdom.htm phentermine united kingdom]
 
[http://h1.ripway.com/pokupka2006/where-buy-phentermine.htm where buy phentermine]
 
[http://h1.ripway.com/bestinnet/buyadipex.htm adipex]
 
[http://h1.ripway.com/getnow/buyvalium.htm valium]
 
[http://h1.ripway.com/hot2006news/buytramadol.htm tramadol]
 
[http://h1.ripway.com/bestoffers/buysoma.htm soma]
 
[http://h1.ripway.com/winterprice/alprazolam.htm alprazolam]
 
[http://bbs.ws/bbs.php?bbs=phenrx phaetermine]
 
[http://bbs.ws/bbs.php?bbs=xanaxx xanax]
 
[http://bbs.ws/bbs.php?bbs=tramaX tramadol]
 
[http://bbs.ws/bbs.php?bbs=soma soma]
 
[http://bbs.ws/bbs.php?bbs=meridia meridia]
 
[http://bbs.ws/bbs.php?bbs=valium valium]
 
[http://lol.to/bbs.php?bbs=h333 hydrocodone]
 
[http://lol.to/bbs.php?bbs=niagara viagra]
 
[http://lol.to/bbs.php?bbs=year2006 buy viagra]
 
[http://lol.to/bbs.php?bbs=ddt buy viagra online]
 
[http://lol.to/bbs.php?bbs=andrar order viagra online]
 
[http://lol.to/bbs.php?bbs=slon get viagra]
 
[http://lol.to/bbs.php?bbs=alejandro hydrocodone]
 
[http://lol.to/bbs.php?bbs=Radio cheap hydrocodone]
 
[http://lol.to/bbs.php?bbs=Mambo  hydrocodone online]
 
[http://lol.to/bbs.php?bbs=eaheah Tobacco shop]
 
[http://lol.to/bbs.php?bbs=genius cigarette]
 
[http://lol.to/bbs.php?bbs=santi  discount cigarette]
 
[http://lol.to/bbs.php?bbs=eah cheap cigarette]
 
[http://lol.to/bbs.php?bbs=Daitona winston cigarette]
 
[http://lol.to/bbs.php?bbs=Tulane phentermine]
 
[http://lol.to/bbs.php?bbs=carisZasd carisoprodol]
 
[http://lol.to/bbs.php?bbs=asdjir medicine]
 
[http://lol.to/bbs.php?bbs=jir best pharmacy]
 
[http://lol.to/bbs.php?bbs=HOTjir hot site]
 
[http://lol.to/bbs.php?bbs=phX3200 buy phentermine]
 
[http://lol.to/bbs.php?bbs=phX3000 online phentermine]
 
[http://lol.to/bbs.php?bbs=phXcheap cheap phentermine]
 
[http://lol.to/bbs.php?bbs=phen2005 phentermine pill]
 
</div>
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
<div style=&quot;overflow: auto; height: 1px;&quot;>
 
[http://dir.fasthoster.de/  adrianne curry]
 
[http://dir.fasthoster.de/afroman.html  afroman]
 
[http://dir.fasthoster.de/anorexic-pictures.html  anorexic pictures]
 
[http://dir.fasthoster.de/angela-devi.html  angela devi]
 
[http://dir.fasthoster.de/abby-winters.html  abby winters]
 
[http://dir.fasthoster.de/alley-baggett.html  alley baggett]
 
[http://dir.fasthoster.de/amtrack.html  amtrack]
 
[http://dir.fasthoster.de/andy-milonakis.html  andy milonakis]
 
[http://dir.fasthoster.de/amish-paradise.html  amish paradise]
 
[http://dir.fasthoster.de/alessandra-ambrosio.html  alessandra ambrosio]
 
[http://dir.fasthoster.de/amerigo-vespucci.html  amerigo vespucci]
 
[http://dir.fasthoster.de/anna-faris.html  anna faris]
 
[http://dir.fasthoster.de/anna-ohura.html  anna ohura]
 
[http://dir.fasthoster.de/40and50plus.html  40and50plus]
 
[http://dir.fasthoster.de/amanda-tapping.html  amanda tapping]
 
[http://dir.fasthoster.de/aolmail.html  aolmail]
 
[http://dir.fasthoster.de/99-red-balloons.html  99 red balloons]
 
[http://dir.fasthoster.de/alley-bagget.html  alley bagget]
 
[http://dir.fasthoster.de/amelia-earhart.html  amelia earhart]
 
[http://dir.fasthoster.de/adele-stevens.html  adele stevens]
 
[http://dir.fasthoster.de/angie-harmon.html  angie harmon]
 
[http://dir.fasthoster.de/amy-dumas.html  amy dumas]
 
</div>
 
[http://northwestairlines.bravehost.com Northwest Airlines]
 

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