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 vote183 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
0 vote201 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote199 views1 answer
How to get one year old query from plan cache
SQL
4 votes193 views1 answer
Oracle select first 10 rows
SQL
15 votes174 views4 answers
T-sql drop function if exists
SQL
31 votes200 views3 answers
SQL Server change column data type
SQL
10 votes178 views2 answers
Linux command line import mysql database
SQL
0 vote378 views1 answer
Get first match in each group mysql query
SQL
0 vote219 views1 answer
How to retrive the today date sql
SQL
0 vote181 views2 answers
Drop check constraint in ms sql
SQL