SQLServer2019-向表中添加数据

向部门表插入数据

nsert into Department(DepartmentName,DepartmentRemark)
values('市场部','......')
insert into Department(DepartmentName,DepartmentRemark)
values('软件部','......')
insert into Department(DepartmentName,DepartmentRemark)
values('企划部','......')

简写

• 插入数据(简写语法)(不推荐使用-数据表结构变化的时候,数据会出错)

insert into Department values('硬件部','......')
insert into Department values('总经办','......')

一次性插入多行数据

insert into Department(DepartmentName,DepartmentRemark)
select'测试部','......'union
select'实施部','......'union
select'产品部','......'

向职级表插入数据

insert into[Rank](RankName,RankRemark)
values('初级','均衡发展')
insert into[Rank](RankName,RankRemark)
values('中级','专攻唱跳或Rap')
insert into[Rank](RankName,RankRemark)
values('高级','大队长carry全场')

向员工表插入数据

insert into People(DepartmentId,RankId,PeopleName,PeopleSex,PeopleBirth,PeopleSalary,
PeoplePhone,PeopleAddress,PeopleAddTime)
values(1,1,'马嘉祺','男','2002-12-12','100000','15691705920','河南',getdate())

insert into People(DepartmentId,RankId,PeopleName,PeopleSex,PeopleBirth,PeopleSalary,
PeoplePhone,PeopleAddress,PeopleAddTime)
values(2,2,'丁程鑫','男','2002-2-24','90000','15691705921','四川',getdate())

insert into People(DepartmentId,RankId,PeopleName,PeopleSex,PeopleBirth,PeopleSalary,
PeoplePhone,PeopleAddress,PeopleAddTime)
values(3,3,'宋亚轩','男','2004-3-4','80000','15691705922','山东',getdate())

insert into people(DepartmentId,RankId,PeopleName,PeopleSex,PeopleBirth,PeopleSalary,
PeoplePhone,PeopleAddress,PeopleAddTime)
values(4,4,'刘耀文','男','2005-9-23','70000','15691705923','重庆',getdate())

insert into People(DepartmentId,RankId,PeopleName,PeopleSex,PeopleBirth,PeopleSalary,
PeoplePhone,PeopleAddress,PeopleAddTime)
values(5,5,'张真源','男','2003-4-16','60000','15691705925','重庆',getdate())

insert into People(DepartmentId,RankId,PeopleName,PeopleSex,PeopleBirth,PeopleSalary,
PeoplePhone,PeopleAddress,PeopleAddTime)
values(6,6,'严浩翔','男','2004-8-16','50000','15691705926','广东',getdate())

insert into People(DepartmentId,RankId,PeopleName,PeopleSex,PeopleBirth,PeopleSalary,
PeoplePhone,PeopleAddress,PeopleAddTime)
values(7,7,'贺峻霖','男','2004-6-14','50000','15691705927','四川',getdate())

• 查看插入数据

select*from Department
select*from[Rank]
select*from People