Horje
INSERT INTO table using OpenQuery Code Example
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



Sql

Related
MySQL PARTITION BY month automatically Code Example MySQL PARTITION BY month automatically Code Example
sql delimiter to columns Code Example sql delimiter to columns Code Example
datetime postgres typeorm Code Example datetime postgres typeorm Code Example
sql find leading space Code Example sql find leading space Code Example
how to find total working hour in sql Code Example how to find total working hour in sql Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje