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 vote186 views1 answer
Xampp increame mysql speed
SQL
6 votes177 views4 answers
Delete table sqlite
SQL
3 votes190 views2 answers
Mysql config user password
SQL
0 vote196 views1 answer
Get the Db column names from a SqlDataReader
SQL
0 vote196 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote176 views2 answers
Insert into
SQL
5 votes191 views1 answer
Oracle find foreign key dependencies
SQL
0 vote194 views1 answer
Sql find record cannot cast date
SQL
9 votes206 views6 answers
Oracle substring
SQL
0 vote193 views1 answer
Mysql grant grant option
SQL