111,094
社区成员




--建表
create table Family
(
FID int primary key,
ParentName varchar(20),
Addr varchar(50)
)
create table Children
(
CID int identity(1,1) primary key,
FID int,
ChildName varchar(20),
Age int,
)
--测试数据
insert into Family (FID, ParentName,Addr) values (1, '张三', '中华大街');
insert into Family (FID, ParentName,Addr) values (2, '李四', '云海南路');
insert into Family (FID, ParentName,Addr) values (3, '王五', '和平小巷');
insert into Children (FID, ChildName,Age) values (1, '张小', 10);
insert into Children (FID, ChildName,Age) values (2, '李一', 8);
insert into Children (FID, ChildName,Age) values (2, '李二', 12);
insert into Children (FID, ChildName,Age) values (3, '王龙', 13);
insert into Children (FID, ChildName,Age) values (3, '王虎', 10);
insert into Children (FID, ChildName,Age) values (3, '王凤', 7);