数据库之2 insert into updata

create database Emppless
on primary
(
--创建数据库 
name = EmpItem,
size = 5mb,
filename ='f:\吴安学习\数据库\数据库练习\Emppless.mdf',
filegrowth =20%
)
log on
(
name =EmpItem_log,
size =5mb,
filename ='f:\吴安学习\数据库\数据库练习\Emppless_log.ldf',
filegrowth = 20%
)
use Emppless
create table DepartmentTable
(
--自动ID  部门 字段名 类型 属性
 AutoID int identity(1,1) primary key,
 DepartmentName nVarchar(50)
)
insert into DepartmentTable(DepartmentName)
values('总经办')
insert into DepartmentTable(DepartmentName)
values('人事资源部')
insert into DepartmentTable(DepartmentName)
values('销售部')
insert into DepartmentTable(DepartmentName)
values('研发部')
insert into DepartmentTable(DepartmentName)
values('采购部')
select * from DepartmentTable
--创建员工表
create table EmpTable
(
--自动ID 姓名 性别 年龄 身份证号码 部门
AutoID  int identity(1,1) primary key,
Name    nvarchar(20) ,
Gender  nvarchar(1),
age     int ,
IdentityCard nvarchar(5),
Department  int 
)

insert into EmpTable (Name,Gender,age,IdentityCard,Department)
values('tom','男' ,30,'12345',1)

insert into EmpTable (Name,Gender,age,IdentityCard,Department)
values('jack','男' ,30,'12356',2)
insert into EmpTable (Name,Gender,age,IdentityCard,Department)
values('steve','男' ,30,'12356',2)
insert into EmpTable (Name,Gender,age,IdentityCard,Department)
values('sk','女' ,30,'13456',2)
insert into EmpTable (Name,Gender,age,IdentityCard,Department)
values('kun','男' ,30,'12456',3)
insert into EmpTable (Name,Gender,age,IdentityCard,Department)
values('sn','男' ,30,'12356',3)
insert into EmpTable (Name,Gender,age,IdentityCard,Department)
values('张三','男' ,30,'12356',3)
insert into EmpTable (Name,Gender,age,IdentityCard,Department)
values('李四','女' ,30,'12456',3)
insert into EmpTable (Name,Gender,age,IdentityCard,Department)
values('张四','男' ,30,'12346',3)
insert into EmpTable (Name,Gender,age,IdentityCard,Department)
values('李五','女' ,30,'12346',4)
insert into EmpTable (Name,Gender,age,IdentityCard,Department)
values('张六','男' ,30,'12356',4)
insert into EmpTable (Name,Gender,age,IdentityCard,Department)
values('李为','女' ,30,'12345',5)
insert into EmpTable (Name,Gender,age,IdentityCard,Department)
values('张七','男' ,30,'123456',5)
insert into EmpTable (Name,Gender,age,IdentityCard,Department)
values('李七','女' ,30,'12346',5)
insert into EmpTable (Name,Gender,age,IdentityCard,Department)
values('张y','男' ,33,'12456',5)
select * from EmpTable

update EmpTable set age =age+1 where Gender=N'男' and age=30
select * from EmpTable