create database FactoryWork
go
use FactoryWork
go
create table employee
(
employeeID int not null primary key,
employeeName char(20) not null,
employeeSex char(2) not null,
employeeOrder int not null,
employeeCallPhone int null,
employeeAddress Text null
)
alter table employee
add constraint DF_Order default (1) for employeeOrder
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('张三',1,'女',198456875,'地府十三层',1)
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('李四',5,'女',5684257,'地府十五层',2)
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('唐僧',3,'男',5454128,'人界唐朝天国',3)
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('猪八戒',6,'男',78454455,'朱家庄',4)
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('孙悟空',8,'男',75214546,'花果山水帘洞',5)
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('观世音',4,'女',521158,'紫竹林',6)
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('如来佛',15,'男',52545624,'大西天',7)
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('玉帝',20,'男',4244874,'天庭',8)
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('西王母',11,'女',84597125,'昆仑山',9)
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('炎帝',16,'男',3548975,'不周仙山',10)
insert into employee values (11,'死老鬼','男',6,89452447,'迷雾鬼林')
select * into employeeBack from employee --where employeeSex ='男'
insert into employeeBack select * from employee where employeeSex =''
select * from employeeBack
delete from employee where employeeID>=1 and employeeID <=11
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('炎帝',16,'男',3548975,'不周仙山',10)
insert into employee values (30,'小李飞刀','男',6,4545,'原始森林')
insert into employee values (31,'一点红','男',3,454,'秘密绝境')
insert into employee values (32,'神州七号','女',8,4121,'太空站')
alter table employee drop PK__employee__7C8480AE
insert into employee select * from employeeBack
select * from employee
use master
go
--drop database FactoryWork
go
use FactoryWork
go
create table employee
(
employeeID int not null primary key,
employeeName char(20) not null,
employeeSex char(2) not null,
employeeOrder int not null,
employeeCallPhone int null,
employeeAddress Text null
)
alter table employee
add constraint DF_Order default (1) for employeeOrder
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('张三',1,'女',198456875,'地府十三层',1)
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('李四',5,'女',5684257,'地府十五层',2)
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('唐僧',3,'男',5454128,'人界唐朝天国',3)
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('猪八戒',6,'男',78454455,'朱家庄',4)
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('孙悟空',8,'男',75214546,'花果山水帘洞',5)
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('观世音',4,'女',521158,'紫竹林',6)
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('如来佛',15,'男',52545624,'大西天',7)
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('玉帝',20,'男',4244874,'天庭',8)
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('西王母',11,'女',84597125,'昆仑山',9)
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('炎帝',16,'男',3548975,'不周仙山',10)
insert into employee values (11,'死老鬼','男',6,89452447,'迷雾鬼林')
select * into employeeBack from employee --where employeeSex ='男'
insert into employeeBack select * from employee where employeeSex =''
select * from employeeBack
delete from employee where employeeID>=1 and employeeID <=11
insert into employee (employeeName,employeeOrder,employeeSex,employeeCallPhone,employeeAddress,employeeID) values ('炎帝',16,'男',3548975,'不周仙山',10)
insert into employee values (30,'小李飞刀','男',6,4545,'原始森林')
insert into employee values (31,'一点红','男',3,454,'秘密绝境')
insert into employee values (32,'神州七号','女',8,4121,'太空站')
alter table employee drop PK__employee__7C8480AE
insert into employee select * from employeeBack
select * from employee
use master
go
--drop database FactoryWork