ALTER TABLE dbo.RdRecord
ADD CONSTRAINT FK__RdRecord__cWhCod__00F4FB67 FOREIGN KEY( cWhCode )
REFERENCES [dbo].[Warehouse] ( cWhCode )
ON UPDATE NO ACTION
ON DELETE NO ACTION
RdRecord表中有cWhCode记录,但Warehouse 表中无cWhCode记录,如何强行的增加此约束再请教
客户端登录SQL服务器时如何取得客户端机器名
ADD CONSTRAINT FK__RdRecord__cWhCod__00F4FB67 FOREIGN KEY( cWhCode )
REFERENCES [dbo].[Warehouse] ( cWhCode )
ON UPDATE NO ACTION
ON DELETE NO ACTION
RdRecord表中有cWhCode记录,但Warehouse 表中无cWhCode记录,如何强行的增加此约束再请教
客户端登录SQL服务器时如何取得客户端机器名
ADD CONSTRAINT FK__RdRecord__cWhCod__00F4FB67 FOREIGN KEY( cWhCode )
REFERENCES [dbo].[Warehouse] ( cWhCode )
ON UPDATE NO ACTION
ON DELETE NO ACTION
ALTER TABLE dbo.RdRecord WITH NOCHECK
ADD CONSTRAINT FK__RdRecord__cWhCod__00F4FB67 FOREIGN KEY( cWhCode )
REFERENCES [dbo].[Warehouse] ( cWhCode )
ON UPDATE NO ACTION
ON DELETE NO ACTION另一种是先更新数据,将数据作处理后,使数据符合约束条件后,再增加约束:ALTER TABLE dbo.RdRecord
ADD CONSTRAINT FK__RdRecord__cWhCod__00F4FB67 FOREIGN KEY( cWhCode )
REFERENCES [dbo].[Warehouse] ( cWhCode )
ON UPDATE NO ACTION
ON DELETE NO ACTION