试试这样:ALTER TABLE chargetable ADD CONSTRAINT [FK_chargetable_unittable] FOREIGN KEY
(
[cardnum]
)REFERENCES unittable
(
[cardnum]
)
GOALTER TABLE chargetable ADD CONSTRAINT [FK_chargetable_persontable] FOREIGN KEY
(
[cardnum]
)REFERENCES persontable
(
[cardnum]
)
GO
(
[cardnum]
)REFERENCES unittable
(
[cardnum]
)
GOALTER TABLE chargetable ADD CONSTRAINT [FK_chargetable_persontable] FOREIGN KEY
(
[cardnum]
)REFERENCES persontable
(
[cardnum]
)
GO
断言该如何加入?
当chargetable的cardnum的值在unittable的cardnum字段中存在,而不在persontable的cardnum字段中时于与FK_chargetable_persontable关系冲突!
可有人知道。
as
if(exists(select a.cardnum from unittable a join chargetable b where a.cardnum=b.cardnum))
begin
insert into chargetable values(值1,值2,....)
end