|
Features
|
SQL
Language
SQL/XML-IMDB
supports a significant subset of the SQL92 definition of the SQL database
language, including support of the following:
- SELECT,
UPDATE, INSERT, DELETE
- CREATE
TABLE...[PRIMARY KEY...]
- DROP
[TABLE]
- SELECT
qualifiers: DISTINCT, TOP n
- SELECT
clauses FROM, WHERE, GROUP BY, HAVING, ORDER BY
- WHERE
expressions: AND, OR, NOT, LIKE, BETWEEN, + - * /, IS [NOT]
- NULL,
<, >, =, < >, <=, >=, Constants, Parameters, Column
Names
- SELECT
list expressions: MAX, MIN, AVG, SUM, COUNT, +, -, *, /,
- Constants,
Parameters, Column Names
- Value
list qualifiers: ANY, ALL, SOME, IN
- UPDATE
expressions: +, -, *, /, Constants, Parameters, Column Names
- INSERT
values expressions: Constants, Parameters
- INSERT
... SELECT
- Sub-queries
within SELECT statements
Supported Data Types
|
Numeric
|
4 bytes – 2,147,483,648 to 2,147,483,647
INT, INTEGER, SHORT, LONG, SMALLINT
|
|
Decimal
|
8 bytes (See DOUBLE)
REAL, FLOAT, DOUBLE, SINGLE, CURRENCY
|
|
Bool
|
1 bit
BOOL, BOOLEAN, YESNO
|
|
Counter
|
4 bytes Auto-Increment value 1 to 2,147,483,647
COUNTER
|
|
Character
|
1 byte per character (2 bytes for UNICODE)
Zero to a maximum of 256 MB/row
CHAR(n), VARCHAR(n),
CHARACTER(n), TEXT
|
|
Date/Time
|
8 bytes 0 to year 20.000,
Time 00:00:00.000.000.0
to 24:59:59.999.999.999
100 nano-seconds resolution
DATE, TIME, DATETIME
|
|
Binary
|
Zero to a maximum of 256 MB/row
BLOB, LONGBINARY
|
|
|
NEW
|
|
XML IFilter
|
|
Crawl,
index and search arbitrary structured xml files based on content.
Extends
functionality of:
SharePoint Portal Server
SharePoint Team Service
MS Indexing Service
MS Site Server
Other Indexing Products
Read more…
|
|
