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

0 vote275 views1 answer
Mysql select where text contains
SQL
2 votes311 views2 answers
Spring import sql
SQL
0 vote278 views1 answer
Sql cross apply vs join
SQL
1 vote277 views1 answer
Mysql history command
SQL
3 votes298 views2 answers
Oracle sql select all days between two dates except weekends
SQL
4 votes309 views1 answer
Data types in sql
SQL
3 votes287 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote298 views1 answer
Ver usuarios mysql
SQL
0 vote244 views1 answer
Connection error in mysql workbench
SQL
3 votes293 views1 answer
Postgresql db owner change
SQL