ALTER TABLE [dbo].[Categorys] ADD
CONSTRAINT [FK_Categorys_Categorys] FOREIGN KEY
(
[ParentCategory]
) REFERENCES [dbo].[Categorys] (
[Category]
) ON UPDATE NO ACTION,
CONSTRAINT [FK_Categorys_Categorys1] FOREIGN KEY
(
[ChildCategory]
) REFERENCES [dbo].[Categorys] (
[Category]
) ON UPDATE NO ACTION
GO
有没有办法可以及连更新呢?我的表示关联的啊,为什么不能更新?
Category varchar(40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
ParentCategory as Category ,
ChildCategory as Category ,
OnBrotherCategory varchar(40) COLLATE Chinese_PRC_CI_AS NULL ,
UnderBrotherCategory varchar(40) COLLATE Chinese_PRC_CI_AS NULL ,
Description varchar(250) COLLATE Chinese_PRC_CI_AS NULL
)
GOALTER TABLE [dbo].[Categorys] WITH NOCHECK ADD
CONSTRAINT [PK_Categorys] PRIMARY KEY CLUSTERED
(
[Category]
) ON [PRIMARY]
insert Categorys(Category,OnBrotherCategory,UnderBrotherCategory ,Description)
select 'a','d','d','d'
update Categorys
set Category='c'
select * from categorys