SQL Server 2008 R2 - generating INSERT statements for a table
Learned something new today. Maybe it’s well-known, but new to me, you can just run “C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Publishing\1.4\SqlPubWiz.exe”. This nifty little tool can generate INSERT script very easily. Pictures tell the story :)
Comments
Anonymous
May 19, 2011
Finally!!!! Thanks for this post, nothing else I found works with Microsoft SQL Server Management Studio Express 2008 R2Anonymous
April 05, 2014
The comment has been removedAnonymous
September 25, 2014
Thank you for the excellent info !