呵呵,诉苦呢?!看你的贴,我回复了.触发器可能 需要这样修改:CREATE TRIGGER inhouse_stock ON dbo.t_device_inhouse
FOR INSERT
ASinsert into t_device_stock
(D_code,D_position,D_in_price,D_st_now,D_provider,D_telno,D_buyer,D_weight,D_name)
select
D_code,D_position,D_in_price,D_in_number,D_provider,D_telno,D_buyer,D_weight,D_name
from inserted
WHERE NOT EXISTS (
SELECT * FROM t_device_stock
WHERE t_device_stock.KEYCOL=inserted.COLNAME ------这里的KEYCOL为t_device_stock的主键,加这些是为了防止有重复纪录.
)
go
FOR INSERT
ASinsert into t_device_stock
(D_code,D_position,D_in_price,D_st_now,D_provider,D_telno,D_buyer,D_weight,D_name)
select
D_code,D_position,D_in_price,D_in_number,D_provider,D_telno,D_buyer,D_weight,D_name
from inserted
WHERE NOT EXISTS (
SELECT * FROM t_device_stock
WHERE t_device_stock.KEYCOL=inserted.COLNAME ------这里的KEYCOL为t_device_stock的主键,加这些是为了防止有重复纪录.
)
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货