A long-lost SQL standard

Source: Internet
Author: User

For a long time there is no job to refer to the SQL standard, and even sql:2011 update has not been to pay attention to. SQL standard along the way, can be said to be slightly senility, the participation of the manufacturers are relatively few, the attention of the people are less. Most people bring up the SQL standard, and the content is actually the most basic or core part of SQL89 or SQL92. In fact, since sql:1999 began, it has been fat. The vast majority of people do not need to go to the word reading standards, and every time the standard updates, there will be members of the Committee to provide a better presentation of the document. For example, there is a good introduction to the latest Sql:2011,sigmod record:

Just a bit more of the standard update, this article just introduces the characteristics of the non sequential database. The features that are more likely to be encountered are:

1. Delete inside the merge statement

2. pipelined DML: You can select from old and new tables directly

3. Enhanced Call Statement

The official standard is to be paid for, but the voting version before the official release is available for download, for example: http://www.jtc1sc32.org/doc/

If you need to know more, look up the first PDF reference.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.