[DB-SIG] Database Independent SQL

[Chris Cogdon]

On Sunday, Sep 8, 2002, at 19:31 US/Pacific, Huy Do wrote:

>> My recommendation: Put as much as possible into stored
>> procedures/functions and views. Then you'll likely be able to use a 
>> very
>> minimal subset of SQL.
>>
>
> Wouldn't I still need to port these stored procedures across databases
> anyway or is there a database independent way of writing these things ?

MySQL, for example, supports neither views nor stored procedures.

While cutting down on the amount of SQL embedded in your code (which 
could be a good thing), it's not very conductive for portability.

--
    ("`-/")_.-'"``-._        Chris Cogdon <chris@cogdon.org>
     . . `; -._    )-;-,_`)
    (v_,)'  _  )`-.\  ``-'
   _.- _..-_/ / ((.'
((,.-'   ((,/   fL