CREATE TABLE [NewProduct] (
[FactoryID] [nvarchar] (50) primary key,
[CustomerID] [nvarchar] (50) ,
[Comment] [nvarchar] (255),
)
GO
CREATE TABLE [OldProduct] (
[FactoryID] [nvarchar] (50) primary key,
[CustomerID] [nvarchar] (50) ,
[Comment] [nvarchar] (255),
)
GO
insert newproduct values( '95588 ', 'ICBC ', 'nothing ')
insert OldProduct values( '95599 ', 'ABC ', 'nothing ')
现在要把两个表关联，实现 新插入的FactoryID在两个表中都是唯一的）
例如：不允许以下语句执行？
insert newproduct values( '95599 ', 'ABC ', 'nothing ')
谢谢
------解决方案--------------------
create trigger tri_name
on NewProduct
instead of insert
as
if not exists (select * from newproduct a where exists(select 1 from inserted where FactoryID=a.FactoryID)) and exists(select * from OldProduct b where exists(select 1 from inserted where FactoryID=b.FactoryID))
begin
insert newproduct select * from inserted
insert OldProduct select * from inserted
end