How to copy data from a table in one database to a table in another db t-sql

Jump to: navigation, search

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

Use your Android as a Chamberlain garage door opener remote

Personal tools
Namespaces
Variants
Views
Actions
Navigation