In Sql Server 2005, is there any way, using the official GUI or a third party tool, to select rows in a table and then generate a insert script for the selected rows?
3 Answers
I do not know of tool that lets you do this using a nice GUI, but I do know of a nice stored procedure that you can use to generate inserts, based on select statement. The script was created by a guy named Narayana Vyas Kondreddi.
You can learn more about the script here.
You would use it like this:
EXEC sp_generate_inserts 'titles', @From = "from titles where title like '%Computer%'"
It's a real time-saver.
SQuirreL SQL can do this:
Highlight a SELECT statement, then invoke Session/Scripts/Create data script from SQL.
-
I can only get SQuirrel to copy specific columns from the rows into an insert, not the entire row. Jul 1, 2009 at 18:25
-
Hm, if you do something like "SELECT * from tableA", then mark the whole statement with the mouse and invoke the menu option given above, it should work. How did you do it?– sleskeJul 1, 2009 at 22:58
-
I'm having the same problem: Squirrel won't give me an INSERT script on a select(*)– DexygenOct 18, 2012 at 18:54