sql server 中创建emp 和dept 数据

guokeeiron

于 2023-04-06 13:17:34 发布

阅读量516

点赞数

分类专栏： sql 文章标签：数据库 sql java

本文链接：https://blog.csdn.net/guokeeiron/article/details/129987140

版权

sql 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

这篇文章展示了如何使用SQL语句创建和插入数据到几个相关联的数据库表中，包括EMP（员工）、DEPT（部门）、BONUS（奖金）和SALGRADE（薪水等级）。这些表包含了员工的个人信息、职位、薪水、部门信息以及薪水等级等详细数据。

摘要由CSDN通过智能技术生成


CREATE TABLE "BONUS" (
"ENAME" VARCHAR(100)  ,
"JOB" VARCHAR(100)  ,
"SAL" money  ,
"COMM" decimal(10,2)  
);

CREATE TABLE "DEPT" (
"DEPTNO"  int  NOT NULL ,
"DNAME" VARCHAR(140) NULL ,
"LOC" VARCHAR(130) NULL 
);


CREATE TABLE "EMP" (
"EMPNO" int NOT NULL ,
"ENAME" VARCHAR(100) NULL ,
"JOB" VARCHAR(90) NULL ,
"MGR" int NULL ,
"HIREDATE" DATE NULL ,
"SAL" money NULL ,
"COMM" decimal(7,2) NULL ,
"DEPTNO" int NULL 
);


CREATE TABLE "SALGRADE" (
"GRADE" int NULL ,
"LOSAL" int NULL ,
"HISAL" int NULL 
);


INSERT INTO DEPT VALUES ('10', 'ACCOUNTING', 'NEW YORK');
INSERT INTO DEPT VALUES ('20', 'RESEARCH', 'DALLAS');
INSERT INTO DEPT VALUES ('30', 'SALES', 'CHICAGO');
INSERT INTO DEPT VALUES ('40', 'OPERATIONS', 'BOSTON');



INSERT INTO EMP VALUES ('7369', 'SMITH', 'CLERK', '7902',  '1980-12-17 00:00:00' , '800', null, '20');
INSERT INTO EMP VALUES ('7499', 'ALLEN', 'SALESMAN', '7698',  '1981-02-20 00:00:00' , '1600', '300', '30');
INSERT INTO EMP VALUES ('7521', 'WARD', 'SALESMAN', '7698',  '1981-02-22 00:00:00' , '1250', '500', '30');
INSERT INTO EMP VALUES ('7566', 'JONES', 'MANAGER', '7839',  '1981-04-02 00:00:00' , '2975', null, '20');
INSERT INTO EMP VALUES ('7654', 'MARTIN', 'SALESMAN', '7698',  '1981-09-28 00:00:00' , '1250', '1400', '30');
INSERT INTO EMP VALUES ('7698', 'BLAKE', 'MANAGER', '7839',  '1981-05-01 00:00:00' , '2850', null, '30');
INSERT INTO EMP VALUES ('7782', 'CLARK', 'MANAGER', '7839',  '1981-06-09 00:00:00', '2450', null, '10');
INSERT INTO EMP VALUES ('7788', 'SCOTT', 'ANALYST', '7566',  '1987-04-19 00:00:00' , '3000', null, '20');
INSERT INTO EMP VALUES ('7839', 'KING', 'PRESIDENT', null,  '1981-11-17 00:00:00' , '5000', null, '10');
INSERT INTO EMP VALUES ('7844', 'TURNER', 'SALESMAN', '7698',  '1981-09-08 00:00:00' , '1500', '0', '30');
INSERT INTO EMP VALUES ('7876', 'ADAMS', 'CLERK', '7788',  '1987-05-23 00:00:00' , '1100', null, '20');
INSERT INTO EMP VALUES ('7900', 'JAMES', 'CLERK', '7698',  '1981-12-03 00:00:00', '950', null, '30');
INSERT INTO EMP VALUES ('7902', 'FORD', 'ANALYST', '7566',  '1981-12-03 00:00:00' , '3000', null, '20');
INSERT INTO EMP VALUES ('7934', 'MILLER', 'CLERK', '7782',  '1982-01-23 00:00:00' , '1300', null, '10');


INSERT INTO "SALGRADE" VALUES ('1', '700', '1200');
INSERT INTO "SALGRADE" VALUES ('2', '1201', '1400');
INSERT INTO "SALGRADE" VALUES ('3', '1401', '2000');
INSERT INTO "SALGRADE" VALUES ('4', '2001', '3000');
INSERT INTO "SALGRADE" VALUES ('5', '3001', '9999');