Standard SQL comment

I used to think that the C-language style comment "/*… */"Is a standard SQL comment. Today, I checked the sql92 specification and found that the standard comment is" -- ". Of course, notes such as sql92 can only comment a row, which has its limitations.

By the way, I checked various SQL standard versions. As follows:

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 LevelSQL-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-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]