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 vote272 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
5 votes267 views1 answer
How to check port number for postgresql
SQL
0 vote284 views2 answers
Sql query inner join 3 tables
SQL
2 votes298 views1 answer
Where clause for child record apex
SQL
-2 votes267 views1 answer
Mysql see users and passwords
SQL
0 vote272 views1 answer
Commit transaction sql
SQL
0 vote260 views1 answer
1 column values in to 1 single row in sql
SQL
1 vote265 views1 answer
Mysql remove last empty newline
SQL
0 vote294 views1 answer
Mariadb create index if not exists
SQL
4 votes305 views1 answer
Mysql delete last row
SQL