所以,你按照saucer(思归) 的方法插入数据是可以的
insert into Tabel_a (A_ID,A_other) values(1,N'hello')
go
insert into Tabel_a (A_ID,A_other) values(2,N'world')
go
select * from tabel_a
go
insert into Table_b (WebID,B_other) values(1,N'B-world')
go
insert into Table_b (WebID,B_other) values(2,N'C-world')
go
select * from table_b
go
而如果你按照一下语句插入,就会出唯一性错误:
insert into Tabel_a (A_ID,A_other) values(1,N'hello')
go
insert into Tabel_a (A_ID,A_other) values(2,N'world')
go
select * from tabel_a
go
insert into Table_b (WebID,B_other) values(1,N'B-world')
go
insert into Table_b (WebID,B_other) values(2,N'C-world')
go
insert into Table_b (WebID,B_other) values(2,N'C-world1')
go
select * from table_b
go
it works for me (by the way, you'd better rename TABEL_A to TABLE_A to be consistent)
insert into Tabel_a (A_ID,A_other) values(1,N'hello')
go
insert into Tabel_a (A_ID,A_other) values(2,N'world')
go
select * from tabel_a
go
insert into Table_b (WebID,B_other) values(1,N'B-world')
go
insert into Table_b (WebID,B_other) values(2,N'C-world')
go
select * from table_b
go
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TABLE_C_TABLE_B]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[TABLE_C] DROP CONSTRAINT FK_TABLE_C_TABLE_B
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_TABLE_B_Tabel_a]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[TABLE_B] DROP CONSTRAINT FK_TABLE_B_Tabel_a
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TABLE_B]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TABLE_B]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TABLE_C]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TABLE_C]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Tabel_a]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Tabel_a]
GO
CREATE TABLE [dbo].[TABLE_B] (
[B_id] [int] IDENTITY (1, 1) NOT NULL ,
[webID] [int] NOT NULL ,
[B_other] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[TABLE_C] (
[C_ID] [int] IDENTITY (1, 1) NOT NULL ,
[webID] [int] NOT NULL ,
[C_other] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Tabel_a] (
[A_id] [int] NOT NULL ,
[webID] [int] IDENTITY (1, 1) NOT NULL ,
[A_other] [nchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TABLE_B] WITH NOCHECK ADD
CONSTRAINT [PK_TABLE_B] PRIMARY KEY CLUSTERED
(
[webID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TABLE_C] WITH NOCHECK ADD
CONSTRAINT [PK_TABLE_C] PRIMARY KEY CLUSTERED
(
[webID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Tabel_a] WITH NOCHECK ADD
CONSTRAINT [PK_Tabel_a] PRIMARY KEY CLUSTERED
(
[webID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TABLE_B] ADD
CONSTRAINT [FK_TABLE_B_Tabel_a] FOREIGN KEY
(
[webID]
) REFERENCES [dbo].[Tabel_a] (
[webID]
) ON DELETE CASCADE ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[TABLE_C] ADD
CONSTRAINT [FK_TABLE_C_TABLE_B] FOREIGN KEY
(
[webID]
) REFERENCES [dbo].[TABLE_B] (
[webID]
) ON DELETE CASCADE ON UPDATE CASCADE
GO