SQL Server的查询操作

1.自主导入Oracle中的scott数据库

        分创三个表的原因：避免信息冗余。

        具体代码实现如下(可供参考)：

create table dept
(
deptno int not null primary key,
loc    varchar(300),
dname    varchar(100)
)

CREATE TABLE emp
(
empno INT NOT NULL PRIMARY KEY,
ename VARCHAR(30),
job VARCHAR(30),
mgr INT,
datet DATETIME,
sal FLOAT,
comm FLOAT,
deptno INT
)

CREATE TABLE salgrade
(
GRADE INT NOT NULL PRIMARY KEY,
LOSAL FLOAT,
HISAL FLOAT
)

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',1456.00,800.00,20);
INSERT INTO emp VALUES(7499,'ALLEN','SALESMAN',7698,'1981-2-20',1600.00,300.00,30);
INSERT INTO emp VALUES(7521,'WARD','SALESMAN',7698,'1981-2-22',1250.00,500.00,30);
INSERT INTO emp VALUES(7566,'JONES','MANAGER',7839,'1981-4-2',2975.00,2300.00,20);
INSERT INTO emp VALUES(7654,'MARTIN','SALESMAN',7698,'1981-9-28',1250.00,1400.00,30);
INSERT INTO emp VALUES(7698,'BLAKE','MANAGER',7839,'1981-5-1',2850.00,1020.00,30);
INSERT INTO emp VALUES(7782,'CLARK','MANAGER',7839,'1981-6-9',2450.00,200.00,10);
INSERT INTO emp VALUES(7788,'SCOTT','ANALYST',7566,'1987--4-19',3000.00,2000.00,20);
INSERT INTO emp VALUES(7839,'KING','PRESIDENT',7765,'1981-11-17',5000.00,1500.00,10);
INSERT INTO emp VALUES(7844,'TURNER','SALESMAN',7698,'1981-9-8',1500.00,0.00,30);
INSERT INTO emp VALUES(7876,'ADAMS','CLERK',7788,'1987-5-23',11000.00,2500,20);
INSERT INTO emp VALUES(7900,'JAMES','CLERK',7698,'1981-12-3',9500.00,600.00,30);
INSERT INTO emp VALUES(7902,'FORD','ANALYST',