INSERT INTO TableName
SELECT *
FROM OPENDATASOURCE('SQLOLEDB' , 'Data Source=10.1.1.1;User ID=sa;Password=sa').DBName.dbo.TableName
WHERE SaleDate >= '2015-1-1'
--openrowset
--openquery
--opendatasource
INSERT INTO TableName
SELECT *
FROM OPENDATASOURCE('SQLOLEDB' , 'Data Source=10.1.1.1;User ID=sa;Password=sa').DBName.dbo.TableName
WHERE SaleDate >= '2015-1-1'
--openrowset
--openquery
--opendatasource