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

13 votes380 views3 answers
Mysqldump structure only
SQL
0 vote319 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
0 vote324 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
17 votes373 views3 answers
Postgresql list users
SQL
0 vote376 views1 answer
PostgreSQL types and C# types
SQL
1 vote318 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote320 views1 answer
Copied text from internet not inserting in mysql
SQL
3 votes336 views4 answers
Order by desc postgres
SQL
0 vote306 views1 answer
Mysql create table like
SQL
0 vote343 views1 answer
Shortcut run sql pgadmin
SQL