sqlÖвé³öµÚ¶þÌõÐÅÏ¢

SQL code:

create database test --½¨Á¢testÊý¾Ý¿â
use test
create table BONUS --½¨Á¢
(
ENAME NVARCHAR(10),
JOB NVARCHAR(9),
SAL FLOAT,
COMM FLOAT
)

create table DEPT --½¨Á¢²¿Ãűí
(
DEPTNO SMALLINT not null, --²¿ÃűàºÅ
DNAME NVARCHAR(14), --²¿ÃÅÃû
LOC NVARCHAR(13), --³ÇÊÐ
primary key (DEPTNO)
)
;

create table EMP --½¨Á¢Ô±¹¤±í
(
EMPNO SMALLINT not null, --Ô±¹¤±àºÅ
ENAME NVARCHAR(10), --Ô±¹¤ÐÕÃû
JOB NVARCHAR(9), --¸Úλ
MGR SMALLINT, --¾­Àí
HIREDATE DATETIME, --¹ÍÓ¶ÈÕÆÚ
SAL FLOAT, --¹¤×Ê
COMM FLOAT, --ͨѶ·Ñ
DEPTNO SMALLINT, --²¿ÃűàºÅ
primary key (EMPNO),
foreign key (DEPTNO) references DEPT (DEPTNO)
)
;

create table SALGRADE --Ô±¹¤¼¶±ð
(
GRADE SMALLINT, --µÈ¼¶
LOSAL SMALLINT, --×îµÍ¹¤×Ê
HISAL SMALLINT --×î¸ß¹¤×Ê
)
;

insert into DEPT (DEPTNO, DNAME, LOC)
values (10, 'ACCOUNTING', 'NEW YORK');
insert into DEPT (DEPTNO, DNAME, LOC)
values (20, 'RESEARCH', 'DALLAS');
insert into DEPT (DEPTNO, DNAME, LOC)
v