Converting Select results into Insert script – SQL Server [closed]

I have SQL Server 2008, SQL Server Management Studio.

I need to select data from Table1 in database1. Then I have to edit some values in the results and insert values into Table1 in database2.

Or let me put it other way.

How can I convert the data in one table into insert script.

Answer

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.