Oracle has MERGE. Search for UPSERT and SQL Server.
On 3/22/07, Doug <[EMAIL PROTECTED]> wrote:
The conflict algorithms in SQLite are brilliant. It's exactly what I've
needed, and after working with SQLite for so long, I had forgotten that it
wasn't part of the SQL standard (as far as I know--but it should be!!!)
For those of you using MS SQL or Oracle, is there any way to get the same
result without first selecting and then doing an insert/update depending on
what I find? (ie I want to put a value into a table. If it's there fine,
and if not, just add it). I know I should ask this in a MS SQL forum, but I
figure you folks are quite familiar with the end goal (which is to make MS
SQL behave like SQLite).
Thanks for any ideas.
Doug
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation http://www.osgeo.org/education/
---------------------------------------------------------------------
collaborate, communicate, compete
=====================================================================
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
