Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Variants vs. Standard ANSI?

Variants vs. Standard ANSI?

Variants vs. Standard ANSI?

My question: Is there a published study /useful source showing ANSI standard versus Vendor-specific features such that one can design & use a database in a sufficiently ANSI-generic way as to escape most or all of the problems one can envisage from running one 'design-and-code' set against different vendors' RDBMSes?

It is, btw, a low-throughput OLTP system with total row-numbers coming in below 100,000 -- i.e. not big!

I'm moving an application away from flat files to an RDBMS. This means establishing the ground rules for dealing with different offerings from Oracle, Sybase, MS. Why? Well, the application will be going into customer sites where they may have their own copy of one of these RDBMSes. This would seem to mean simply writing everything "ANSI compliant" ... but where does that get you?
In a posting elsewhere,
"The technique offered.... was first posted by well-known SQL Guru Joe Celko .... Joe participated in the creation of the ANSI SQL-92 standard, and thus is a strong supporter of ANSI SQL-92 compliant code. Joe frequently makes the point that code written to the SQL-92 standard is portable to any database that supports the standard."

This raises the question: "What vendors support the standard?"
From what I've seen so far, data-types, expressions, functions (and, consequently, results?) will differ according to which vendor-product one uses.

I have the book "The Practical SQL HAndbook" 4th ed. which does list some differences, but apparently only in areas that the book itself 'uses' in its examples. These variants seem to be mostly 'syntactical'; the absence / presence of un/desirable features, I think, isn't included.

Your helpful comments / information will be most welcome! -- Michael Russell

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close