（SqlBulkCopy批量插入）使用临时表上触发器插入或更新数据（存在的更新，没有的插入

IF OBJECT_ID('tabminuteData','U') IS NOT NULL
	DROP TABLE tabminuteData
GO

CREATE TABLE tabminuteData(
	TT INT,
	R1H INT,
	StationID INT , 
	ObservTime DATETIME
)
GO

-- 创建与主表结构一致的临时表
IF object_id('Tmp_tabminuteData','U') IS NOT NULL
	DROP TABLE Tmp_tabminuteData
GO

CREATE TABLE Tmp_tabminuteData(
	TT INT,
	R1H INT,
	StationID INT , 
	ObservTime DATETIME
)
GO

IF object_id('tr_Tmp_tabminuteData','TR') IS NOT NULL
	DROP TRIGGER tr_Tmp_tabminuteData
GO

CREATE TRIGGER tr_Tmp_tabminuteData ON Tmp_tabminuteData 
AFTER INSERT
AS
BEGIN
	
	---- 方法一：SQL2008之后版本支持
	MERGE
		dbo.tabminuteData AS Target1
	USING 
		Inserted Ins ON Ins.StationID = Target1.StationID AND Ins.ObservTime = Target1.ObservTime
	WHEN MATCHED THEN 
		UPDATE SET Target1.TT = Ins.TT,Target1.R1H = Ins.R1H
	WHEN NOT MATCHED THEN
		INSERT(
			tt,R1H,StationID,ObservTime) 
		VALUES( 
			tt,R1H,StationID,ObservTime);


	----方法二：SQL2008以前的版本用这个方法
	--UPDATE 
	--	tabminuteData 
	--SET 
	--	TT=b.TT,R1H=b.R1H
	--FROM 
	--	tabminuteData a JOIN inserted b 
	--ON a.StationID=b.StationID AND a.ObservTime=b.ObservTime
	
	--INSERT 
	--	tabMinuteData 
	--SELECT 
	--	* 
	--FROM 
	--	inserted a
	--WHERE NOT EXISTS( 
	--	SELECT 
	--		TOP 1 1
	--	FROM 
	--		tabminuteData b 
	--	WHERE 
	--		a.StationID=b.StationID AND a.ObservTime=b.ObservTime 
	--)
	
	-- 最后删除临时表的数据
	DELETE Tmp_tabminuteData
END
GO

-- 测试
DELETE tabminuteData
GO
INSERT dbo.Tmp_tabminuteData
( TT, R1H, StationID, ObservTime )
VALUES
(1,1,1,'2015-07-30 12:07:01'),
(2,2,2,'2015-07-30 12:07:02'),
(3,3,3,'2015-07-30 12:07:03')
GO

SELECT * FROM dbo.tabminuteData
INSERT dbo.Tmp_tabminuteData
( TT, R1H, StationID, ObservTime )
VALUES
(3,3,1,'2015-07-30 12:07:01'),
(1,1,3,'2015-07-30 12:07:03'),
(4,4,4,'2015-07-30 12:07:04')
GO
SELECT * FROM dbo.tabminuteData
SELECT * FROM dbo.Tmp_tabminuteData