Micah
4Penny.net
Points: 7559

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.

4Penny.net
Version: All
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3