如果不存在，如何将数据插入我的服务器？ [英] How to insert data to my server if not exists?

问题描述

我尝试将数据从SERVER1导出到SERVER2。我尝试获取最新日期，而不是SERVER1中的所有数据。我想移动表的表格是内容XML数据类型。



我尝试过：

I try to export my data from SERVER1 to SERVER2. I try to get the latest date and not all the data in the SERVER1. The table I would like to move the table do content XML data type.

What I have tried:

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

推荐答案

您在insert语句中的select语句正在服务器2上执行查询。这是故意的吗？此外，该声明中没有日期条款。修复这两件事可以解决你的问题。

Your select statement in the insert statement, is executing query on server 2. Is that intentional? Also, there is no date clause in that statement. Fixing these two things ma solve your problem.

这篇关于如果不存在，如何将数据插入我的服务器？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！