Results 1 to 3 of 3

Thread: Ansi-sql

  1. #1
    Join Date
    Oct 2003
    Location
    uk
    Posts
    12

    Unanswered: Ansi-sql

    does any one know what ANSI-SQL is? and how it is used in Access?thanks

  2. #2
    Join Date
    Jul 2003
    Location
    Amsterdam, Nederland
    Posts
    450

    Thumbs up ANSI

    See your help files and type in ANSY (or copy and past this in word):

    <<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>
    Microsoft Jet database engine SQL is generally ANSI-89 Level 1 compliant. However, certain ANSI SQL features aren't implemented in Microsoft Jet SQL. Conversely, Microsoft Jet SQL includes reserved words and features not supported in ANSI SQL.

    Major Differences

    Microsoft Jet SQL and ANSI SQL each have different reserved words and data types. For more information, see Microsoft Jet Database Engine SQL Reserved Words and Equivalent ANSI SQL Data Types.
    Different rules apply to the Between...And construct, which has the following syntax:

    expr1 [NOT] Between value1 And value2

    In Microsoft Jet SQL, value1 can be greater than value2; in ANSI SQL, value1 must be equal to or less than value2.

    Different wildcard characters are used with the Like operator.
    <<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>
    The following table lists ANSI SQL data types and the equivalent Microsoft Jet database engine SQL data types and their valid synonyms.

    ANSI SQL
    data type Microsoft Jet
    SQL data type
    Synonym
    BIT, BIT VARYING BINARY (See Notes) VARBINARY
    Not supported BIT (See Notes) BOOLEAN, LOGICAL, LOGICAL1, YESNO
    Not supported BYTE INTEGER1
    Not supported COUNTER AUTOINCREMENT
    Not supported CURRENCY MONEY
    DATE, TIME, TIMESTAMP DATETIME DATE, TIME, TIMESTAMP
    Not supported GUID
    DECIMAL Not supported
    REAL SINGLE FLOAT4, IEEESINGLE, REAL
    DOUBLE PRECISION, FLOAT DOUBLE FLOAT, FLOAT8, IEEEDOUBLE, NUMBER, NUMERIC
    SMALLINT SHORT INTEGER2, SMALLINT
    INTEGER LONG INT, INTEGER, INTEGER4
    INTERVAL Not supported
    Not supported LONGBINARY GENERAL, OLEOBJECT
    Not supported LONGTEXT LONGCHAR, MEMO, NOTE
    CHARACTER, CHARACTER VARYING TEXT ALPHANUMERIC, CHAR, CHARACTER, STRING, VARCHAR
    Not supported VALUE (See Notes)
    Notes

    The ANSI SQL BIT data type doesn't correspond to the Microsoft Jet SQL BIT data type, but it corresponds to the BINARY data type instead. There is no ANSI SQL equivalent for the Microsoft Jet SQL BIT data type.
    The VALUE reserved word doesn't represent a data type defined by the Microsoft Jet database engine.

  3. #3
    Join Date
    Oct 2003
    Location
    uk
    Posts
    12

    Re: ANSI

    Originally posted by Marvels
    See your help files and type in ANSY (or copy and past this in word):

    <<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>
    Microsoft Jet database engine SQL is generally ANSI-89 Level 1 compliant. However, certain ANSI SQL features aren't implemented in Microsoft Jet SQL. Conversely, Microsoft Jet SQL includes reserved words and features not supported in ANSI SQL.

    Major Differences

    Microsoft Jet SQL and ANSI SQL each have different reserved words and data types. For more information, see Microsoft Jet Database Engine SQL Reserved Words and Equivalent ANSI SQL Data Types.
    Different rules apply to the Between...And construct, which has the following syntax:

    expr1 [NOT] Between value1 And value2

    In Microsoft Jet SQL, value1 can be greater than value2; in ANSI SQL, value1 must be equal to or less than value2.

    Different wildcard characters are used with the Like operator.
    <<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>
    The following table lists ANSI SQL data types and the equivalent Microsoft Jet database engine SQL data types and their valid synonyms.

    ANSI SQL
    data type Microsoft Jet
    SQL data type
    Synonym
    BIT, BIT VARYING BINARY (See Notes) VARBINARY
    Not supported BIT (See Notes) BOOLEAN, LOGICAL, LOGICAL1, YESNO
    Not supported BYTE INTEGER1
    Not supported COUNTER AUTOINCREMENT
    Not supported CURRENCY MONEY
    DATE, TIME, TIMESTAMP DATETIME DATE, TIME, TIMESTAMP
    Not supported GUID
    DECIMAL Not supported
    REAL SINGLE FLOAT4, IEEESINGLE, REAL
    DOUBLE PRECISION, FLOAT DOUBLE FLOAT, FLOAT8, IEEEDOUBLE, NUMBER, NUMERIC
    SMALLINT SHORT INTEGER2, SMALLINT
    INTEGER LONG INT, INTEGER, INTEGER4
    INTERVAL Not supported
    Not supported LONGBINARY GENERAL, OLEOBJECT
    Not supported LONGTEXT LONGCHAR, MEMO, NOTE
    CHARACTER, CHARACTER VARYING TEXT ALPHANUMERIC, CHAR, CHARACTER, STRING, VARCHAR
    Not supported VALUE (See Notes)
    Notes

    The ANSI SQL BIT data type doesn't correspond to the Microsoft Jet SQL BIT data type, but it corresponds to the BINARY data type instead. There is no ANSI SQL equivalent for the Microsoft Jet SQL BIT data type.
    The VALUE reserved word doesn't represent a data type defined by the Microsoft Jet database engine.

    thanks alot for that, i was just wondering if there is any sort of complaince also with oracle 9i?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •