2011

SQL Condition Syntax
SQL has a strict grammatical structure and syntax. Here are some rules to
follow when you define SQL statements.
■ Character values (data type CHAR) must be enclosed in single quotation
marks ('XXX').
■ If the column has a data type of string or data, enclose the column name
in double quotes. If the column has a numeric data type, do not enclose
the column name in double quotes.
■ Database values are case sensitive, but field (column) names are not.
■ Do not end each statement with a semicolon (;) as in standard SQL syntax.
■ For dates, use the format TIMESTAMP'YYYY-MM-DD 00:00:00'. For example:
"DATE">TIMESTAMP'1993-06-20 11:24:00'
■ Do not use AutoCAD Map 3D or DOS wild cards such as * or ? as part of
column values or names.
■ Do not use SQL keywords as identifiers. Examples of keywords are SQL
commands and data types such as CHAR, GROUP, SQL, TABLE, USER,
SECTION, BY, and CURRENT. Examples of identifiers are table and column
names. For example, if you try to create a table with a column name of
CURRENT, AutoCAD Map 3D displays an error message.
AutoCAD Map 3D supports standard SQL syntax as formally defined in the
ANSI X3.135-1989 SQL standard.
Type SQL Condition dialog box | 1871