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

3 votes132 views1 answer
How to find names includes in sql
SQL
0 vote129 views1 answer
Mysql db dump restore max file size issue
SQL
0 vote125 views1 answer
Mysql does collate nopad recognize space
SQL
2 votes128 views2 answers
Sql query to list all tables in a database sql server
SQL
5 votes143 views1 answer
How to get all table names in sql query
SQL
0 vote135 views1 answer
Open postgresql.conf in centos
SQL
2 votes130 views3 answers
Row number mysql
SQL
2 votes132 views1 answer
Sql ignore accents
SQL
0 vote111 views1 answer
Sql trim whitespace
SQL
3 votes169 views2 answers
@sqlresultsetmapping
SQL