3

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?

2
  • So instead of a generic insert you want the data specific to the selected row(s), correct?
    – squillman
    Jul 1, 2009 at 14:41
  • Right. My issue is that I insert rows with the SQL Server GUI and then want to copy inserted rows to other servers. Jul 1, 2009 at 14:46

3 Answers 3

5

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.

3

SQuirreL SQL can do this:

Highlight a SELECT statement, then invoke Session/Scripts/Create data script from SQL.

3
  • 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?
    – sleske
    Jul 1, 2009 at 22:58
  • I'm having the same problem: Squirrel won't give me an INSERT script on a select(*)
    – Dexygen
    Oct 18, 2012 at 18:54
-1

I would recommend you to use SQL Tool Belt from RedGate link text

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .