Re: Using both MS SQL and Oracle
Date: Mon, 14 May 2001 21:50:56 -0700
Message-ID: <3B00B5B0.5EAFEBA8_at_exesolutions.com>
Lee Miller wrote:
> Huh? since when is Transact-SQL a flavor of VBA?
I slight correct to what you wrote if I may be permitted.
It is not a case of the SQL "can" be vastly different but rather a case of the
SQL "will" be vastly different and "should" be vastly different. About the only
place the two products are close is in the way Microsoft hypes its product in
its advertising to blur the distinction.
>
> And yes, Bryon as others have said it can be done. The SQL can be vastly
> different (at least in my Experience with Oracle 7.3 and SQL Server 6.5 it
> is). Particularly joins and other aggregate queries. Even the invocation
> of stored procedures is different 'exec' under SQL server and 'execute'
> under Oracle. So using stored procedures to hide the differences in code is
> not as simple as you may think.
>
Daniel A. Morgan Received on Tue May 15 2001 - 06:50:56 CEST