【SQL开源代码栏目提醒】:网学会员--在 SQL开源代码编辑为广大网友搜集整理了:insertEmployees.sql绩等信息,祝愿广大网友取得需要的信息,参考学习。
INSERT INTO [hr].[dbo].[Employees]([EmpId], [EmpName], [Sex], [Title], [Wage], [DepId])
VALUES(1, '李强', '男', '部门经理', 3000, 1)
INSERT INTO [hr].[dbo].[Employees]([EmpId], [EmpName], [Sex], [Title], [Wage], [DepId])
VALUES(2, '张丽', '女', '职员', 1500, 1)
INSERT INTO [hr].[dbo].[Employees]([EmpId], [EmpName], [Sex], [Title], [Wage], [DepId])
VALUES(3, '高宾', '男', '部门经理', 3100, 2)
INSERT INTO [hr].[dbo].[Employees]([EmpId], [EmpName], [Sex], [Title], [Wage], [DepId])
VALUES(4, '严飞', '男', '职员', 1600, 2)
INSERT INTO [hr].[dbo].[Employees]([EmpId], [EmpName], [Sex], [Title], [Wage], [DepId])
VALUES(5, '李宇', '男', '部门经理', 3200, 3)
INSERT INTO [hr].[dbo].[Employees]([EmpId], [EmpName], [Sex], [Title], [Wage], [DepId])
VALUES(6, '赵娜', '女', '职员', 1400, 3)
INSERT INTO [hr].[dbo].[Employees]([EmpId], [EmpName], [Sex], [Title], [Wage], [DepId])
VALUES(7, '马佳', '女', '部门经理', 3100, 4)
INSERT INTO [hr].[dbo].[Employees]([EmpId], [EmpName], [Sex], [Title], [Wage], [DepId])
VALUES(8, '杨颖', '女', '职员', 1500, 4)