标准SQL注释

      原来一直以为C语言风格的注释“/* … */”是标准SQL注释,今天查SQL92规范,才发现标准的注释是“--”。当然,SQL92这种注释只能注释一行,有其局限性。

   顺便查了一下SQL标准的各种版本。如下:

1986
SQL-86
SQL-87
First formalized by ANSI.

1989
SQL-89
FIPS 127-1
Minor revision, adopted as FIPS 127-1.

1992
SQL-92
SQL2, FIPS 127-2
Major revision (ISO 9075), Entry Level SQL-92 adopted as FIPS 127-2.

1999
SQL:1999
SQL3
Added regular expression matching, recursive queries, triggers, support for procedural and control-of-flow statements, non-scalar types, and some object-oriented features.

2003
SQL:2003
Introduced XML-related features, window functions, standardized sequences, and columns with auto-generated values (including identity-columns).

2006
SQL:2006
ISO/IEC 9075-14:2006 defines ways in which SQL can be used in conjunction with XML. It defines ways of importing and storing XML data in an SQL database, manipulating it within the database and publishing both XML and conventional SQL-data in XML form. In addition, it enables applications to integrate into their SQL code the use of XQuery, the XML Query Language published by the World Wide Web Consortium (W3C), to concurrently access ordinary SQL-data and XML documents.

2008
SQL:2008
Legalizes ORDER BY outside cursor definitions. Adds INSTEAD OF triggers. Adds the TRUNCATE statement.[21]

评论 4
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值