SELECT * FROM OPENQUERY (SERVER1, 'SELECT EmployeeID, EmployeeName, JoinDate, CAST([XMLContent] AS NVARCHAR(MAX)) FROM dbo.Computer.tblEmployee WHERE JoinDate=>'23-02-2016' ') IF NOT EXISTS (SELECT * FROM OPENQUERY ([SERVER2], 'SELECT EmployeeID, EmployeeName, JoinDate, CAST([XMLContent] FROM dbo.Computer.tblEmployee')) BEGIN INSERT INTO dbo.Computer.tblEmployee SELECT * FROM OPENQUERY ([SERVER2], 'SELECT EmployeeID, EmployeeName, JoinDate, CAST([XML] FROM dbo.Computer.tblEmployee') END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)