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 vote169 views1 answer
Join in update query in mysql
SQL
1 vote184 views1 answer
Get table column names sql ssms
SQL
7 votes256 views2 answers
3rd height salary sql
SQL
0 vote186 views1 answer
Greater than or equal to symbol in postgres
SQL
5 votes183 views1 answer
Oracle get foreign keys on table
SQL
2 votes171 views1 answer
Mysql select random id from table
SQL
2 votes184 views4 answers
2nd highest salary in mysql
SQL
1 vote180 views1 answer
Get url of cpanel database hostname
SQL
0 vote172 views1 answer
Sql transact create cursor with dynamic tables
SQL
1 vote186 views1 answer
Rename table column name in mysql
SQL