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 vote311 views3 answers
Mysql on delete set null
SQL
0 vote272 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
0 vote311 views1 answer
Mysql command line top 10
SQL
3 votes266 views1 answer
Mysql UPDate with enner join
SQL
2 votes287 views1 answer
Change primary key sql
SQL
0 vote288 views1 answer
What is the difference between now() and current_date()?
SQL
7 votes286 views2 answers
Add column table pl sql
SQL
2 votes316 views3 answers
Mysql kill
SQL
0 vote295 views1 answer
Database db connection string format
SQL
0 vote289 views1 answer
Sqlite3 update select
SQL