6 ms·
How about the syntactical difference between "insert into <x> ..." and "update <x> set...". I've always wondered why no vendor has an "insertorupdate" function
by mistermann 17y ago
How about the syntactical difference between "insert into <x> ..." and "update <x> set...". I've always wondered why no vendor has an "insertorupdate" function. This issue, from an application development perspective, is another reason I love ORM's. The idea that, in the year 2010, I have to write at least two stored proc's for each table in my database, just for persisting data, aggravates me.
- DenisM 17y agoBut they do! MERGE works in both SQL Server and Oracle. See, this goes back to my point - people aren't learning their tools and then complain about perceived lack of functionality. I suggest hitting stackoverflow with this type of questions in the future. That's what I always do when I wonder "can I do X with Y?".