This script has now been relocated to GitHub. Future updates will be posted there.

You can always download the latest version from:

https://github.com/readyroll/generate-sql-merge/archive/master.zip

More info:

https://github.com/readyroll/generate-sql-merge

I have made a revision to the proc to get around the 8192 character limit of SSMS.

It uses XML to output the results by default. After executing the proc, simply...

john.moreno (4/16/2012)

The problem is that PRINT can only print 4000/8000 characters (depending upon whether it is varchar or nvarchar), so the solution depends upon your data.

If all of the textual...

Thanks John!

I've made a few changes based on your suggestions and attached v0.92:

1) The generated script now includes a "USE [DatabaseName]" statement at the start, if the @include_use_db (bit) param...

Thanks for that John, I've revised the script to include the Primary Key check.

Unfortunately I'm not able to edit the original article, so have zipped the SQL file here:

Thanks for providing that alternate implementation Celko.

I can definitely see advantages of your approach, but I have a question: how would one remove extraneous records with your script?

Say I work...

Hi Luke,

Great article! Thanks very much for sharing.

I was a little curious though... given that the CRUD statements are done automatically by your stored proc, where do you do the...