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 vote254 views1 answer
How refresh navicat tables to see new tables
SQL
0 vote291 views1 answer
T-sql update table variale
SQL
0 vote262 views1 answer
Search In the Data using ObjectName
SQL
0 vote279 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
6 votes257 views1 answer
What is where clause in sql
SQL
1 vote288 views2 answers
Mysql switch case
SQL
3 votes260 views1 answer
Force using index oracle
SQL
1 vote264 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote259 views1 answer
Inser into example
SQL
4 votes282 views1 answer
W3schools create table
SQL