News for hackers. Stuff that matters.

A comment on Announcing SQL Server on Linux. Parent comment

Re:Announcing SQL Server on Linux by jklowden on Monday March 07, 2016 @07:57PM (#11242891)
Oh, then that's your problem. MERGE is standard, and has clear semantics. UPSERT is nonstandard, and semantics vary among implementations.

Microsoft doesn't need to make SQL Server look like MySQL. Quite the other way around.

[ Parent | on HN ]
Re:Announcing SQL Server on Linux by techdragon on Monday March 07, 2016 @09:30PM (#11243214)
There's not really a standard anymore for UPSERT to be added to. SQL has fragmented and since the last few iterations of the standard allowed for "additional non standard features", adding an UPSERT is perfectly compliant with the SQL standards.
[ Parent | on HN ]
Re:Announcing SQL Server on Linux by manigandham on Monday March 07, 2016 @11:29PM (#11243546)
UPSERT should be a standard, why isn't it?

And it's very useful in a ton of situations which is why so many other SQL dialects have added it. It's not like SQL Server is completely standards compliant so I'd rather have the functionality then have to use MERGE because it's "standard".

[ Parent | on HN ]