Pluralsight & Packt Author, Director, CTO, Software Architect, Team leader, Tutor, Speaker, Software Developer. I like to make fast scalable things using C# and SQL Server.
Friday 14 May 2010
Generating Insert Statements
Quite a good article by Oleg Netchaev on how to automatically generate INSERT statements for a given table.
The SQL for this is available here.
If you only want a small subset generated, then have a look at the SSMS Tools Pack which is free.