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 vote180 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
0 vote185 views1 answer
Sqlserver now
SQL
0 vote226 views1 answer
How to find top 3 salary in sql
SQL
-1 vote223 views1 answer
Difference berween database and data base management system
SQL
0 vote196 views1 answer
Selecting all columns from table sql database
SQL
1 vote210 views3 answers
Divide by zero error in sql
SQL
0 vote164 views1 answer
Oracle index hint multiple tables example
SQL
1 vote190 views2 answers
Procedure syntax
SQL
0 vote169 views1 answer
Oracle sql winter time change
SQL
0 vote190 views1 answer
Import mysql'
SQL