Revision as of 07:13, 10 March 2007 edit John Vandenberg (talk \| contribs) Extended confirmed users 68,510 edits m avoid redirects, Replaced: Java → Java using AWB ← Previous edit		Revision as of 18:35, 27 May 2007 edit undo Bovineone (talk \| contribs) Extended confirmed users, Pending changes reviewers 15,306 edits turn new features into a bulleted list. add a couple more and incorporate a reference. split standard availability into a new section Next edit →
Line 3: '''SQL:2003''' is the fifth revision of the [[SQL]] [[database]] [[query language]]. It makes minor modifications to all parts of [[SQL:1999]], and officially introduces a few new features such as:<ref>{{cite web\|url=http://www.acm.org/sigmod/record/issues/0403/index.html#standards\|last=Eisenberg\|first=Andrew\|coauthors=et al.\|title=SQL:2003 Has Been Published\|format=pdf}}</ref> ~~Introduced XML-related features, ''window functions'', standardized sequences and columns with auto-generated values (including identity-columns).~~ * XML-related features * ''window functions'' * the sequence generator, which allows standardized sequences * two new column types: auto-generated values and identity-columns * the new [[Merge (SQL)\|Merge]] statement ==Documentation availability== The SQL standard is not freely available. SQL:2003 may be purchased from [http://www.iso.org/ ISO] or [http://webstore.ansi.org/ ANSI]. A late draft is available as a [http://www.wiscorp.com/sql_2003_standard.zip zip archive] from [http://www.wiscorp.com/ Whitemarsh Information Systems Corporation]. The zip archive contains a number of [[Portable Document Format\|PDF]] files that define the parts of the SQL:2003 specification. ==External links==▼ * [http://www.acm.org/sigmod/record/issues/0403/index.html#standards Eisenberg et al.: ''SQL:2003 Has Been Published''] * [http://savage.net.au/SQL/sql-2003-1.bnf.html BNF Grammar for ISO/IEC 9075-1:2003] – SQL/Framework▼ * [http://savage.net.au/SQL/sql-2003-2.bnf.html BNF Grammar for ISO/IEC 9075-2:2003] – SQL/Foundation▼ * ISO/IEC 9075(1-4,9-11,13,14):2003 CD-ROM (352 [[Swiss franc\|CHF]], or approximately 225 [[Euro\|EUR]], to order the CD) [http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=34132 ISO/IEC 9075-1:2003] – Framework (SQL/Framework) Line 21 ⟶ 22: [http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=37102 ISO/IEC 9075-13:2003] – SQL Routines and Types Using the [[Java (programming language)\|Java]] Programming Language (SQL/JRT) ** [http://www.iso.org/iso/en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=35341 ISO/IEC 9075-14:2003] – XML-Related Specifications (SQL/XML) ==References== {{reflist}} ▲==External links== ▲* [http://savage.net.au/SQL/sql-2003-1.bnf.html BNF Grammar for ISO/IEC 9075-1:2003] – SQL/Framework ▲* [http://savage.net.au/SQL/sql-2003-2.bnf.html BNF Grammar for ISO/IEC 9075-2:2003] – SQL/Foundation [[Category:SQL\| ]]

SQL:2003: Difference between revisions