Home / server / Questions / 34495
In Process
James McMahon
Asked: 2009-07-02 06:32:29 +0800 CST

Generating an insert script based on selected rows in Sql Server?

  • 772

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?

sql-server scripting database

3 Answers

  1. 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.

    • 5

  2. SQuirreL SQL can do this:

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

    • 3

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

    • -1