create table t1
(
id int primary key identity(1,1) not null,
name varchar(10)
)
insert into t1 values ('aaa')
insert into t1 values ('bbb')
insert into t1 values ('ccc')
insert into t1 values ('ddd')
insert into t1 values ('eee')create table t2
(
id int not null,
sscore int not null
)
alter table t2
add constraint fk_id_t1 foreign key (id) references t1(id)
insert into t2 values (1,65)
insert into t2 values (3,89)
(
id int primary key identity(1,1) not null,
name varchar(10)
)
insert into t1 values ('aaa')
insert into t1 values ('bbb')
insert into t1 values ('ccc')
insert into t1 values ('ddd')
insert into t1 values ('eee')create table t2
(
id int not null,
sscore int not null
)
alter table t2
add constraint fk_id_t1 foreign key (id) references t1(id)
insert into t2 values (1,65)
insert into t2 values (3,89)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货