Generate Insert statements from resultsets, tables or database
11
votes

-
Adrian Brough commented
Even better to generate Merge Statements
-
Stephen commented
Up to SQL2008R2 use the free http://www.ssmstoolspack.com/ and you can script a resultset to INSERTs and search it, too. SQL2012 = $$$