-- Instal as a temp stored proc on any SQL edition RAISERROR ('Wrong database context. Please USE [master] to allow sp_generate_merge to be installed as a system ...

This system stored procedure takes a table name as a parameter and generates a MERGE statement containing all the table data. This is useful if you need to migrate static data between databases, eg.

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...

Some will consider it presumptuous for a non-lawyer to take issue with a prestigious panel of the American Bar Association. But in the case of presidential signing statements, the ABA is wrong. The ...