The SQL standard MERGE command would work. Note that H2's MERGE command is already nonstandard extension of the standard. I don't see anything wrong with H2 being a superset of the standard. People can decide for themselves if they want to use nonstandard extensions or not.
On Dec 1, 5:53 pm, Kerry Sainsbury <[email protected]> wrote: > MS SQL Server also supports "update... from", but it has essentially been > superceeded in SQL Server 2008 via the "merge" command. "merge" even > conforms to SQL 2003. > > http://sqlblog.com/blogs/hugo_kornelis/archive/2008/03/10/lets-deprec... > > http://en.wikipedia.org/wiki/Merge_%28SQL%29 > > Of course H2 already supports the "merge" command :-) > > Cheers > Kerry > > On Wed, Dec 2, 2009 at 9:15 AM, Alexander Hartner < > > [email protected]> wrote: > > Is this not an extension to ANSI SQL ? If it is I would prefer not to have > > it to prevent creating database specific code. After all that is the purpose > > of an SQL standard. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
