Sql

Search

INSERT INTO table using OpenQuery

TRUNCATE TABLE mytable

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: SQL COMO ALTERA NOME DE TABELA
Sql :: automatically update database last seen datetime in sql
Sql :: postgresql like
Sql :: neo4j command to run script file
Sql :: codeigniter dbforge add index
Sql :: sql where multiple values
Sql :: h2 auto increment and unique
Sql :: get month from date sql server
Sql :: order by in codeigniter query builder
Sql :: drop procedure postgres
Sql :: create a table from one field of another table
Sql :: how to convert null to float in mysql
Sql :: cte in sql server
Sql :: create table
Sql :: insert data to postgresql from excel
Sql :: sqlite get columns for table
Sql :: mysql multiply
Sql :: advantages of stored procedures sql
Sql :: mysql filter based on datediff
Sql :: function in sql
Sql :: oracle sql procedure return value
Sql :: oracle sql distinct vs unique
Sql :: desc sql
Sql :: Selecting from a view SQL
Sql :: select sql
Sql :: mysql create database
Sql :: convert sql to linq c# online
Sql :: create-toys-table-with-toy_name-column
Sql :: Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?
Sql :: edad en oracle

Search

SQL

INSERT INTO table using OpenQuery

ADD CONTENT