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 vote319 views1 answer
How to get specific salary in sql
SQL
4 votes300 views1 answer
Sql query to make a existing column auto increment
SQL
7 votes286 views2 answers
Create index mysql
SQL
2 votes316 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote285 views1 answer
Dump only schema
SQL
3 votes313 views2 answers
Oracle grants
SQL
0 vote293 views1 answer
Including parameters in OPENQUERY
SQL
0 vote387 views1 answer
How to check common records in 2 table
SQL
0 vote286 views1 answer
Downgrading sql localdb visual studio
SQL
1 vote318 views1 answer
Join first name and last name sql
SQL