C#.rar_asp.net C＃

create database dbCSp go use dbCSproject go create table tbSf ( SfID int identity(101,1) primary key, SfName varchar(20) not null ) go create table tbCz ( czID int identity(101,1) primary key, czName varchar(20) not null, czSfID int not null foreign key references tbSf(SfID) ) go insert into tbSf(SfName) values('陕西省') insert into tbSf(SfName) values('山东省') insert into tbCz(czName,czSfID) values ('西安','101') insert into tbCz(czName,czSfID) values ('山西','101') insert into tbCz(czName,czSfID) values ('青岛','102') insert into tbCz(czName,czSfID) values ('淄博','102') select * from tbSf select * from tbCz