- create database Department
- go
- use Department
- go
- create table TDepartment
- (
- depID int primary key,
- depName varchar(30) not null
- )
- go
- insert into TDepartment values(1,'教务')
- insert into TDepartment values(2,'考务')
- insert into TDepartment values(3,'体育')
- insert into TDepartment values(4,'艺术')
- insert into TDepartment values(5,'财务')
- go
- select * from TDepartment
- go
- create table Emp
- (empID int primary key,
- empName varchar(30) not null,
- depID int foreign key references TDepartment(depID)
- )
- go
- insert into Emp values(1,'John',1)
- insert into Emp values(2,'Smith',1)
- insert into Emp values(3,'Green',2)
- insert into Emp values(4,'Joe',2)
- insert into Emp values(5,'Li',3)
- insert into Emp values(6,'Zhang',3)
- insert into Emp values(7,'Chen',4)
- insert into Emp values(8,'Wang',4)
- insert into Emp values(9,'Liu',5)
- insert into Emp values(10,'Xia',5)
- go
- select *from Emp
- go
数据库创建(SQL语句)--DropdownList&ListBox连动菜单
最新推荐文章于 2020-05-02 12:18:46 发布