You are currently browsing comments. If you would like to return to the full story, you can read the full entry here: “The Merge Statement”.
Random MVP RSS Feeds- [Aaron Bertrand] How SQL Saturday could be better: I've been to a lot of SQL Saturdays. They are great events to... http://t.co/bLe97UD5
- [Aaron Bertrand] SQL Server 2008 R2 Service Pack 2 CTP is available: You can download the service pack 2 CTP fro... http://t.co/kblQTr2y
- [SQLTeam] Why to avoid SELECT * from tables in your Views: -- clean up any messes left over from before: if OB... http://t.co/GIDxRhEY
- [Kalen Delaney] Did You Know? Turning Off Locking: Back when the lock manager was rewritten for SQL Server 7, an... http://t.co/lzEEpC11
- [Aaron Bertrand] A cautionary tale about grandfathering CAL licenses in SQL Server 2012 Enterprise: I've tried t... http://t.co/1Uoru0DD
- [Kalen Delaney] Geek City: Build a Big Table with a Columnstore Index: I was looking all over to find a big tabl... http://t.co/kzBZMTZu
- [SQLTeam] ClearTrace Performance on 170GB of Trace Files: I’ve always worked to make ClearTrace perform well. T... http://t.co/R24uwgOl
- [SQLTeam] ClearTrace Beta for SQL Server 2012: I have a beta version of ClearTrace that supports 2012. You can ... http://t.co/IrXM7ZFb
- User Defined Functions and Performance - There is definitely a lack of... http://t.co/YdHjOTuH #fb
- [Aaron Bertrand] Seacoast SQL Users Group : What's New in SQL Server 2012: Tonight I presented my "What's New in... http://t.co/wL7bT7qg
Connect
Spell check.
Complete.
I am new to this. Since I am coming from a Microsoft SQL Server eovnrinment, and to some other it may seem like the two versions should be very similar, and they are, to a certain degree, but they are also very different in some important and basic ways. Good read, thanks!
when is the merge statement going to have error logging
DML like Oracle… they really missed this one.
Yes, that would be useful. There is a way to do this using SSIS, however having it inline would be nice too.