/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

1 vote186 views1 answer
Substr sql last character
SQL
0 vote274 views1 answer
Sql filter rows with condition
SQL
4 votes241 views1 answer
Mysql query first character
SQL
7 votes184 views6 answers
Group_concat mysql
SQL
0 vote211 views1 answer
Sql on-premises
SQL
0 vote211 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote198 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
5 votes205 views3 answers
Bash: mysql: command not found
SQL
0 vote209 views2 answers
Oracle create tablespace autoextend
SQL
0 vote206 views1 answer
How to install Firebird
SQL