sy1_2.sql

来自「关于SQL数据库的实验代码和程序及一些函数的应用」· SQL 代码 · 共 23 行

use pay
create table pay.dbo.dept
        (deptno  varchar(10)  not null unique,
         deptname varchar(20) not null
         )
create table pay.dbo.person
         (no char(6) primary key,
          name char(10) not null,
          sex char(2)  not null,
          birthday datetime  null,
          professor varchar(12) null,
          deptno varchar(10) not null
                     constraint fk_deptno foreign key references dept(deptno)
         )
create table pay.dbo.pay
         (no char(6) not null,
          year int not null,
          month int  not null,
          base dec(5,1)   null,
          bonus dec(5,1)  null,
          deduct dec(5,1)  null,
          fact as base+bonus-deduct
         )