INSERT INTO table using OpenQuery

TRUNCATE TABLE mytable

INSERT INTO mytable (firstcolumn, secondcolumn)
SELECT firstcolumn, secondcolumn 
FROM OPENQUERY (mylinkedserver, 'SELECT firstcolumn, secondcolumn FROM linkedtable')

Source: stackoverflow.com

Similar codes

0 vote165 views2 answers
Get all index postgres
SQL
5 votes179 views3 answers
Day of week postgresql
SQL
0 vote161 views1 answer
Call function sql oracle
SQL
0 vote164 views1 answer
Suse start MySQL
SQL
3 votes280 views1 answer
Ssh check mysql version
SQL
5 votes164 views1 answer
Alter table add comment oracle
SQL
15 votes208 views5 answers
Show tables in oracle
SQL
0 vote161 views1 answer
Sql insert tuple
SQL
0 vote164 views1 answer
How to order result of subquery in select
SQL
0 vote197 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL