Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

Inside SQL Server 2008: Figure 4: Update and Insert Data with One Statement. The MERGE statement lets you insert, update, and delete data in a table with a single statement. The results shown here ...

SQL Server 2008 provided us with some new T-SQL syntax; one of those that I am most excited about is the new MERGE statement. Gone are the days of IF...THEN logic to decide whether a row needs to be ...

Microsoft's latest relational database management system contains a host of new features, but are they enough to make you migrate? The wait is over. Microsoft has finally released SQL Server 2008, the ...

SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from AJAX queries in joins, updates and any other SQL statement you can think of. SQL Server 2016 provides ...