SQL:2016: Difference between revisions

Revision as of 21:28, 18 June 2017

Revision as of 14:29, 23 August 2017

Line 5:

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:

* [[JavaScript_Object_Notation|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