insert into dbo.TeacherInfo(TeacherName,TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID) 
values('张强',12,1,12,12,'dd',1)
--正确
go
insert into dbo.TeacherInfo(TeacherName,TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID) 
values('张强',12,1,12,12,'dd')--少量一个值，插入数据的值应该对应起来，不能插入半行数据
go

 
insert into dbo.TeacherInfo(TeacherName,TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID) 
values('张强',12,1,12,12,'dd','哦也！我错了')--注意事项2:每个数据值的数据类型、精度和小数位数必须与相应的列匹配；
go
insert into dbo.TeacherInfo(id,TeacherName,TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID) 
values(1,'张强',12,1,12,12,'dd',1)--注意事项3:不能为标识列指定值，因为它的数字是自动增长的；

 
go
insert into dbo.TeacherInfo(TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID) 
values(12,1,12,12,'dd',1)--注意事项4:如果在设计表的时候就指定了某列不允许为空，则必须插入数据；
go
insert into dbo.TeacherInfo(TeacherName,TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID) 
values('张强',12,1,12,12,'dd',100)--注意事项5:插入的数据项，要求符合检查约束的要求
select * from dbo.DepartInfo
--delete from dbo.TeacherInfo where DepartID=100
go
insert into dbo.TeacherInfo(TeacherName,TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID) 
values('张强',12,1,default,12,'dd',1)--注意事项6:具有缺省值的列，可以使用DEFAULT（缺省）关键字来代替插入的数值
go

 

 

 

 

 

 
insert into dbo.TeacherInfo(TeacherName,TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID) 
values('张强',12,1,12,12,'dd',1)
insert into dbo.TeacherInfo(TeacherName,TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID) 
values('张强',12,1,12,12,'dd',1)
insert into dbo.TeacherInfo(TeacherName,TeacherSalary,TeacherWorkOfYeays,TeacherAge,TeacherBirthday,TeacherAddress,DepartID) 
values('张强',12,1,12,12,'dd',1)

 

 

 

 

 

 

 

 
insert into dbo.DepartInfo(DepartName,DepartCount,DepartNote) values('计算机工程系',1,'计算机')
insert into dbo.DepartInfo(DepartName,DepartCount,DepartNote) values('信息工程系',1,'计算机')

 
insert into dbo.DepartInfo(DepartName,DepartCount,DepartNote) values('jinji工程系',1,'计算机')
insert into dbo.DepartInfo(DepartName,DepartCount,DepartNote) values('jijian工程系',1,'计算机')