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 vote152 views1 answer
Update sql join multiple tables
SQL
0 vote202 views1 answer
Mysql user set plugin
SQL
0 vote201 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
11 votes204 views2 answers
Oracle source code
SQL
0 vote193 views1 answer
Json_remove mysql
SQL
0 vote210 views1 answer
Sql server union if table exist
SQL
1 vote202 views1 answer
Temp table vs variable table in sql server
SQL
-1 vote249 views1 answer
Search all sql tables for a value
SQL
25 votes226 views6 answers
How to change column name in mysql
SQL
42 votes296 views6 answers
Rename table sql server
SQL