/SQL/Sql select data from one database and insert into a different database

Sql select data from one database and insert into a different database

USE TargetDatabase
GO

INSERT INTO dbo.TargetTable(field1, field2, field3)
   SELECT field1, field2, field3
     FROM SourceDatabase.dbo.SourceTable
     WHERE (some condition)

-1

Source: stackoverflow.com

Similar codes

0 vote333 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
1 vote390 views2 answers
Laravel jwt generate token
SQL
0 vote333 views1 answer
Mysql repair a table
SQL
0 vote322 views1 answer
Sql search all columns of database oracle sql
SQL
21 votes338 views4 answers
Add column mssql
SQL
0 vote334 views1 answer
T-SQL Never ending DELETE
SQL
2 votes307 views1 answer
Convert series number to date in sql
SQL
23 votes333 views1 answer
How remove column in mysql
SQL
0 vote345 views1 answer
Add a new column into table
SQL
1 vote318 views1 answer
Sql server find tables referenced foreign key
SQL