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 vote246 views1 answer
Bigrock database connection string
SQL
3 votes163 views1 answer
Postgres add not null to existing column
SQL
2 votes166 views4 answers
How to find 2nd highest salary in mysql
SQL
1 vote266 views1 answer
Mysql breakline on string
SQL
0 vote189 views1 answer
Selecting Multiple Columns in SQL
SQL
0 vote150 views1 answer
Events not working db
SQL
0 vote154 views1 answer
Get all employees if name ends with in sql
SQL
1 vote166 views1 answer
Mysql workbench in ubuntu 14.04
SQL
0 vote151 views1 answer
How to order result of subquery in select
SQL
17 votes154 views3 answers
Cast in sql server
SQL