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 vote111 views1 answer
Sql server datetime vs datetime2
SQL
3 votes199 views4 answers
Sql interview questions
SQL
0 vote63 views1 answer
Finish transaction sql
SQL
0 vote116 views1 answer
T sql return on letters only
SQL
1 vote64 views1 answer
Psql kill pid
SQL
0 vote117 views1 answer
Postgresql list extensions
SQL
1 vote117 views1 answer
Mysql take number in string
SQL
5 votes109 views1 answer
How to get all dates in a month in oracle
SQL
0 vote105 views1 answer
Oracle list index on table
SQL
0 vote109 views2 answers
Default constraint in ms sql
SQL