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?
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:
It's a real time-saver.
SQuirreL SQL can do this:
Highlight a SELECT statement, then invoke Session/Scripts/Create data script from SQL.