How to copy data in sql

Migrate sql table another database

INSERT INTO dbo.YourTableNameHere
   SELECT *
   FROM [SourceServer].[SourceDatabase].dbo.YourTableNameHere

How to copy data in sql

INSERT INTO my_table my
SELECT * FROM another_table an
WHERE an.col1 > 10;

INSERT INTO my_table (colA, colB) 
SELECT an.col1 AS colA, an.col2 AS colB FROM another_table an
WHERE an.col1 > 10;

Similar codes

1 vote358 views1 answer
Jooq convert using gbk
SQL
0 vote363 views2 answers
Drop tables from local table database postgres
SQL
24 votes382 views6 answers
Replace mysql
SQL
0 vote342 views1 answer
Show create table in postgresql
SQL
0 vote345 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote409 views1 answer
Sql cursor example multiple columns
SQL
1 vote346 views1 answer
Mysql query bulk insert
SQL
1 vote368 views1 answer
Sql headers delphi
SQL
7 votes350 views1 answer
Safe update mysql
SQL
9 votes323 views3 answers
Mysql get last id
SQL