SqlBulkCopy sbc = new SqlBulkCopy(strCon.ToString(), SqlBulkCopyOptions.FireTriggers);
触发器为:
AFTER INSERT,UPDATE AS
DECLARE @GROUP VARCHAR(200)SELECT @GROUP= COMPANY FROM Statistic_DAY
IF (@GROUP NOT IN (SELECT DISTINCT COMGROUP FROM GROUPBUSSNES))
BEGIN
INSERT GROUPBUSSNES (
COMGROUP,
[EDGE],
[HWL],
[GPRS]
)
SELECT DISTINCT COMPANY,'1','1','1' FROM Statistic_DAY where COMPANY=@GROUP
END
else
begin
update GROUPBUSSNES set [EDGE]='1',[HWL]='1',[GPRS]='1' where COMGROUP=@GROUP
end应该是SqlBulkCopy批量导入的时候不触发,一条条插入。没问题。请教,如何修改!
触发器为:
AFTER INSERT,UPDATE AS
DECLARE @GROUP VARCHAR(200)SELECT @GROUP= COMPANY FROM Statistic_DAY
IF (@GROUP NOT IN (SELECT DISTINCT COMGROUP FROM GROUPBUSSNES))
BEGIN
INSERT GROUPBUSSNES (
COMGROUP,
[EDGE],
[HWL],
[GPRS]
)
SELECT DISTINCT COMPANY,'1','1','1' FROM Statistic_DAY where COMPANY=@GROUP
END
else
begin
update GROUPBUSSNES set [EDGE]='1',[HWL]='1',[GPRS]='1' where COMGROUP=@GROUP
end应该是SqlBulkCopy批量导入的时候不触发,一条条插入。没问题。请教,如何修改!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货