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 vote336 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote336 views1 answer
Get time component of datetime sql
SQL
0 vote346 views1 answer
Sqlalchemy sequence postgresql
SQL
0 vote343 views1 answer
Sql find table by name
SQL
0 vote372 views2 answers
Dumping sql table
SQL
0 vote394 views1 answer
Select true if exists on another table or false sqlserver
SQL
0 vote376 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote399 views1 answer
How to use sqlcommand
SQL
6 votes353 views5 answers
Alter table oracle
SQL
3 votes400 views4 answers
Truncate syntax in sql
SQL