Monday, March 19, 2012

Oracle's Merge equivalent of SQL server?

What is the equivalent of Oracle's Merge statement in SQL server ?UPDATE followed by an INSERT. There isn't a single statement to do it but
you can obviously wrap the two in a transaction if you really need to.
David Portas
SQL Server MVP
--

No comments:

Post a Comment