Search code examples
sqlsql-serversql-server-2008ssms

Converting Select results into Insert script - SQL Server

I have SQL Server 2008, SQL Server Management Studio.

I need to select data from a table in one database and insert into another table in another database.

How can I convert the returned results from my select into INSERT INTO ...?

Clarification from comments: While I believe this could be solved by a INSERT INTO SELECT or SELECT INTO, I do need to generate INSERT INTO ....

Solution

  • SSMS Toolpack (which is FREE as in beer) has a variety of great features - including generating INSERT statements from tables.

    Update: for SQL Server Management Studio 2012 (and newer), SSMS Toolpack is no longer free, but requires a modest licensing fee.