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

2 votes205 views2 answers
Mysql count rows returned
SQL
1 vote242 views3 answers
Nth highest salary
SQL
-1 vote206 views1 answer
Ssms connect with connection string
SQL
62 votes501 views8 answers
Mysql add column
SQL
2 votes203 views2 answers
Create empty table from existing table
SQL
6 votes207 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote199 views1 answer
Sql pick random row
SQL
0 vote241 views1 answer
Take sql dump in to file
SQL
0 vote208 views1 answer
Sql server alter table add column tinyint
SQL
1 vote209 views1 answer
Mysql dump specific tables
SQL