createtable1.sql

该章文件夹Chap2下存放的都是SQL脚本文件

CREATE DATABASE PERSONNEL_SYS1
GO
USE PERSONNEL_SYS1
CREATE TABLE BASE_DATA1
(WORKER_ID  nvarchar (15)  PRIMARY KEY ,
WORKER_NAME nvarchar (8) COLLATE Chinese_PRC_CI_AS NULL ,
DEPARTMENT_NAME nvarchar (15) COLLATE Chinese_PRC_CI_AS NULL ,
SEX nvarchar (2) COLLATE Chinese_PRC_CI_AS NULL ,
)
GO