KEMBAR78
SQL Server Demo Tables | PDF
Scribd
Upload
30 views2 pages

SQL Server Demo Tables

The document contains SQL commands to create and populate three tables: EMP, DEPT, and SALGRADE. The EMP table includes employee details such as employee number, name, job title, manager, hire date, salary, commission, and department number. The DEPT table stores department information, while the SALGRADE table defines salary grades with corresponding salary ranges.

Uploaded by

nandars9052
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
30 views2 pages

SQL Server Demo Tables

The document contains SQL commands to create and populate three tables: EMP, DEPT, and SALGRADE. The EMP table includes employee details such as employee number, name, job title, manager, hire date, salary, commission, and department number. The DEPT table stores department information, while the SALGRADE table defines salary grades with corresponding salary ranges.

Uploaded by

nandars9052
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 2

CREATE TABLE EMP

(
EMPNO SMALLINT ,
ENAME VARCHAR(10),
JOB VARCHAR(9),
MGR NUMERIC(4),
HIREDATE DATE,
SAL MONEY,
COMM MONEY,
DEPTNO TINYINT
)

INSERT INTO EMP VALUES


(7369, 'SMITH', 'CLERK', 7902, '1980-12-17', 800, NULL, 20)

INSERT INTO EMP VALUES


(7499, 'ALLEN', 'SALESMAN', 7698, '20-FEB-1981', 1600, 300, 30)

INSERT INTO EMP VALUES


(7521, 'WARD', 'SALESMAN', 7698, '22-FEB-1981', 1250, 500, 30)

INSERT INTO EMP VALUES


(7566, 'JONES', 'MANAGER', 7839, '2-APR-1981', 2975, NULL, 20)

INSERT INTO EMP VALUES


(7654, 'MARTIN', 'SALESMAN', 7698, '28-SEP-1981', 1250, 1400, 30)

INSERT INTO EMP VALUES


(7698, 'BLAKE', 'MANAGER', 7839, '1-MAY-1981', 2850, NULL, 30)

INSERT INTO EMP VALUES


(7782, 'CLARK', 'MANAGER', 7839, '9-JUN-1981', 2450, NULL, 10)

INSERT INTO EMP VALUES


(7788, 'SCOTT', 'ANALYST', 7566, '09-DEC-1982', 3000, NULL, 20)

INSERT INTO EMP VALUES


(7839, 'KING', 'PRESIDENT', NULL, '17-NOV-1981', 5000, NULL, 10)

INSERT INTO EMP VALUES


(7844, 'TURNER', 'SALESMAN', 7698, '8-SEP-1981', 1500, 0, 30)

INSERT INTO EMP VALUES


(7876, 'ADAMS', 'CLERK', 7788, '12-JAN-1983', 1100, NULL, 20)

INSERT INTO EMP VALUES


(7900, 'JAMES', 'CLERK', 7698, '3-DEC-1981', 950, NULL, 30)

INSERT INTO EMP VALUES


(7902, 'FORD', 'ANALYST', 7566, '3-DEC-1981', 3000, NULL, 20)

INSERT INTO EMP VALUES


(7934, 'MILLER', 'CLERK', 7782, '23-JAN-1982', 1300, NULL, 10)

CREATE TABLE DEPT


(
DEPTNO INT primary key,
DNAME VARCHAR(14),
LOC VARCHAR(13)
)

INSERT INTO DEPT VALUES (10, 'ACCOUNTS', 'NEW YORK')


INSERT INTO DEPT VALUES (20, 'RESEARCH', 'DALLAS')
INSERT INTO DEPT VALUES (30, 'SALES', 'CHICAGO')
INSERT INTO DEPT VALUES (40, 'OPERATIONS', 'BOSTON')

CREATE TABLE BONUS


(ENAME VARCHAR(10),
JOB VARCHAR(9),
SAL NUMERIC,
COMM NUMERIC)

CREATE TABLE SALGRADE


(GRADE NUMERIC,
LOSAL MONEY,
HISAL MONEY)

INSERT INTO SALGRADE VALUES (1, 700, 1000)


INSERT INTO SALGRADE VALUES (2, 1001, 2000)
INSERT INTO SALGRADE VALUES (3, 2001, 3000)
INSERT INTO SALGRADE VALUES (4, 3001, 4000)
INSERT INTO SALGRADE VALUES (5, 4001, 9999)

You might also like