helpinghand
search
needassistance
 

Mimer SQL Standard Compliance

The language SQL (Structured Query Language) is standardized by international standard bodies such as ISO and ANSI. By using standard SQL it should be easier to move applications between different database systems without the need to rewrite a substantial amount of code. Using standard SQL does not give any warranty though as all vendors does not implement all features in the standard.

Mimer Information Technology's policy is to develop Mimer SQL as far as possible in accordance with the established standard. Today, Mimer SQL is compatible in all essential features with the currently accepted SQL standards, which enables users to switch to and from Mimer SQL easily.

In order to assist database developers in writing SQL that conforms to the SQL standard, the Mimer SQL Validator is provided as a free online tool.

SQL Standard Topics

See the following topics to get the full picture:

SQL Standard Organizations

So where can I get these standards? If you want your own copy of SQL Standards, you'll have to purchase it. You can obtain a copy of ISO standards from the International Organization for Standardization at http://www.iso.org/. The main identification for the standard is ISO/IEC 9075, which consists of several parts like for example "ISO/IEC 9075-1:2011 Information technology -- Database languages -- SQL -- Part 1: Framework (SQL/Framework)".

If you would like to read more about SQL, we can recommend a search on your favorite Internet book site for the SQL authorities Joe Celko, Hugh Darwen, Chris Date or Jim Melton. Or visit our Resources page.

 

Powered by Mimer SQL

Powered by Mimer SQL