How to copy data from a table in one database to a table in another db t-sql
<![CDATA[To insert data into myTable in your current DB from a table in myOtherDatabase:
insert into myTable (myColumn1, myColumn2, ...) select myColumn1, myColumn2, ... from myOtherDatabase.dbo.myTable
]]>
See also
