/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 vote194 views2 answers
Sql server concat string and int
SQL
0 vote139 views1 answer
How to set field to null in sql
SQL
0 vote174 views1 answer
Oracle tablespace autoextend
SQL
2 votes194 views1 answer
How to get weekday from old date in sql
SQL
1 vote183 views1 answer
Reutrn string after character sql
SQL
1 vote188 views1 answer
Create temporal table in sql
SQL
0 vote183 views1 answer
Authentication in sql server
SQL
7 votes174 views6 answers
Group_concat mysql
SQL
5 votes274 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
0 vote194 views1 answer
How to find total working hour in sql
SQL