Posted By: Anonymous
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
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.