Ok #SQL folks, a friendly PSA thread:
I know some like to party like it’s SQL-99 (maybe even old school SQL-92), but so much has changed since then. The current standard is SQL-2016 (ISO/IEC 9075:2016) available here:
https://www.iso.org/standard/63555.html …
See also:https://blog.ansi.org/2018/10/sql-standard-iso-iec-9075-2016-ansi-x3-135/ …
-
Show this thread
-
If you are too reluctant to ask your employer pay for the latest standard, you can obtain the SQL-2011 (ISO/IEC 9075-1:2011) one for free here: https://standards.iso.org/ittf/PubliclyAvailableStandards/c053681_ISO_IEC_9075-1_2011.zip … No need to use citations to some outdated version you found on the net somewhere (use ISO/ANSI sites please)
2 replies 1 retweet 2 likesShow this thread -
There are even 7 SQL Technical Reports *freely* available from here (search for 19075): http://standards.iso.org/ittf/PubliclyAvailableStandards/index.html … Noting specifically - Part 6: SQL support for JavaScript Object Notation (JSON) (did I mention **for free**)pic.twitter.com/deHKeAwP3P
1 reply 1 retweet 3 likesShow this thread -
Another great resource is
@ModernSQL and required reading for SQL:2016 -https://modern-sql.com/blog/2017-06/whats-new-in-sql-2016 …4 replies 7 retweets 13 likesShow this thread
listagg is a real "WTF were they _thinking_" botch.
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.