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 vote276 views1 answer
Sql gather statistics to increase performance
SQL
8 votes360 views2 answers
Select current_timestamp - interval '3 days';
SQL
0 vote250 views1 answer
Sql server remove 0 from left
SQL
13 votes266 views2 answers
Oracle select into and inner join
SQL
5 votes251 views1 answer
How to check nls format in oracle
SQL
0 vote246 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote255 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
1 vote261 views1 answer
Oracle turn off constraint
SQL
0 vote243 views2 answers
2nd max salary query in sql
SQL
1 vote237 views1 answer
Oracle current sequence value
SQL