Database compatability

[hplloyd]

Hi,

I am writing an application that I want to work with either a SQL Server
2000 database or an Oracle database.

All of the SQL statements will be coded into the application itself - I do
not want to use stored procedures. My question is this - is there a good book
or other reference material available that will help me ensure that the SQL I
write is compatible with both SQL Server and Oracle? My concern is around
datatypes and in particular manipulating dates within SQL code.

Thanks for any advice given

[Paul Clement]

Re: Database compatability

On Wed, 25 Aug 2004 00:39:07 -0700, "hplloyd" <hplloyd@discus sions.microsoft .com> wrote:

¤ Hi,
¤
¤ I am writing an application that I want to work with either a SQL Server
¤ 2000 database or an Oracle database.
¤
¤ All of the SQL statements will be coded into the application itself - I do
¤ not want to use stored procedures. My question is this - is there a good book
¤ or other reference material available that will help me ensure that the SQL I
¤ write is compatible with both SQL Server and Oracle? My concern is around
¤ datatypes and in particular manipulating dates within SQL code.
¤
¤ Thanks for any advice given

I'm not aware of any reference material that identifies the differences so you will likely need to
digest both PL/SQL and Transact-SQL.

However, if all SQL statements are coded in the application there is practically no chance for
compatibility, that is unless you use the simplest of data access methods. Your chances are far
better with stored procedures since in many instances the data access layer or database server
handles the database specific implementation features.

With respect to the handling of dates in a SQL statement which is passed to the database server for
execution, Oracle typically requires that you use a function called TO_DATE for inserts and updates.


Paul ~~~ pclement@amerit ech.net
Microsoft MVP (Visual Basic)