Sign Up Now!Log In
Micah 6/13/2016 10:11:17 AM

Dynamic INSERT statement

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu

Here's the deal. I'm just tired of writing this script. I have to write it  several times a week.

I'll blog it here and be done with writing it. <smiles>

This is a script that will produce an insert statement for any table in SQL 2008 +

Sure, you can just right click on a table and get this... but my solution is ready to use and requires only minimal editing.

And (for all you OCDers like me) the commas line up.

Version: All
Section: SQL Scripts