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 vote187 views1 answer
Select new table sql
SQL
5 votes162 views1 answer
How to get all dates in a month in oracle
SQL
5 votes217 views1 answer
Migrate sql table another database
SQL
0 vote176 views1 answer
Oracle procedure teamplate
SQL
3 votes113 views1 answer
How to get list of synonyms in oracle
SQL
1 vote188 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote176 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote173 views2 answers
Sql query in dax power bi
SQL
1 vote185 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
25 votes179 views4 answers
Sqlserver add column
SQL