SQL:2016: Difference between revisions

Revision as of 02:49, 14 March 2017

Latest revision as of 10:47, 4 February 2025

(14 intermediate revisions by 14 users not shown)

Line 1:

{{Short description|2016 edition of the SQL standard}}

{{refimprove|date=March 2017}}

{{SQL language revisions}}

{{about|the language standard|''MS SQL 2016'', the Microsoft product|SQL Server 2016}}

'''SQL:2016''' or '''[[ISO 9075|ISO/IEC 9075:2016]]''' (under the general title "Information technology – Database languages – SQL") is the eighth revision of the [[International Organization for Standardization|ISO]] (1987) and [[ANSI]] (1986) standard for the [[SQL]] [[database]] [[query language]]. It was formally adopted in December 2016.<ref>{{Citationcite web needed|date url =March https://www.iso.org/committee/45342/x/catalogue/p/1/u/0/w/0/d/0 | title = ISO/IEC 9075, 13249, and others| access-date=2017-03-15}}</ref> The standard consists of 9 parts which are described in some detail in [[SQL#Interoperability_and_standardization|SQL]]. The next version is [[SQL:2023]].

==New features==

'''SQL:2016''' or '''[[ISO 9075|ISO/IEC 9075:2016]]''' (under the general title "Information technology – Database languages – SQL") is the eighth revision of the [[International Organization for Standardization|ISO]] (1987) and [[ANSI]] (1986) standard for the [[SQL]] [[database]] [[query language]]. It was formally adopted in December 2016.{{Citation needed|date=March 2017}} The standard consists of 9 parts which are described in detail in [[SQL#Interoperability_and_standardization|SQL]].

SQL:2016 introduced 44 new optional features.<ref>{{cite web | url = https://modern-sql.com/blog/2017-06/whats-new-in-sql-2016 | title = What's New in SQL:2016| access-date=2017-06-16}}</ref> 22 of them belong to the JSON functionality, ten more are related to polymorphic table functions. The additions to the standard include:

* [[JSON]]: Functions to create JSON documents, to access parts of JSON documents and to check whether a string contains valid JSON data

* Row Pattern Recognition: Matching a sequence of rows against a [[regular expression]] pattern

* Date and time formatting and parsing

* LISTAGG: A function to transform values from a group of rows into a delimited string

* Polymorphic table functions: table functions without predefined return type

* New data type DECFLOAT

==See also==

{{Wikibook|Structured Query Language}}

* [[SQL]]

* [[b:Structured Query Language|Wikibook SQL]]

==References==

Line 12 ⟶ 24:

==External links==

* {{Citation | url = https://www.iso.org/standard/63555.html | contribution = SQL:2016 | title = Catalogue | publisher = ISO | format = webshop}}.

* [http://standards.iso.org/ittf/PubliclyAvailableStandards/c065143_ISO_IEC_TR_19075-5_2016.zip ISO/IEC TR 19075-5:2016: Row Pattern Recognition in SQL]

* [http://standards.iso.org/ittf/PubliclyAvailableStandards/c067367_ISO_IEC_TR_19075-6_2017.zip ISO/IEC TR 19075-6:2017: SQL support for JavaScript Object Notation (JSON)]

* [http://standards.iso.org/ittf/PubliclyAvailableStandards/c069776_ISO_IEC_TR_19075-7_2017.zip ISO/IEC TR 19075-7:2017: Polymorphic table functions in SQL]

{{SQL}}

[[Category:SQL|* ]]

[[Category:Declarative programming languages]]

[[Category:Query languages]]

[[Category:2016Computer-related introductions in 2016]]

{{Compu-stub}}