Content deleted Content added
Add "New Features" section and links to free technical reports by ISO |
mNo edit summary |
||
Line 1:
'''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>{{cite web | url = https://www.iso.org/committee/45342/x/catalogue/p/1/u/0/w/0/d/0 | title = ISO/IEC 9075, 13249, and others| accessdate=2017-03-15}}</ref> The standard consists of 9 parts which are described in some detail in [[SQL#Interoperability_and_standardization|SQL]].
==New
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| accessdate=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:
| |||