createtable.txt

该章文件夹Chap1下存放的以下4个文件：CreateTable.txt、CreateDB.sql、PERSONNEL_SYS_Data.MDF和PERSONNEL_SYS_Log.LDF。 其中C

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BASE_DATA]') and 
OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[BASE_DATA];

CREATE TABLE [dbo].[BASE_DATA] (
	[WORKER_ID] [nvarchar]  (15)  NOT NULL ,
        [ARCHIVES_ID] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[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 ,
	[BIRTHDAY] [datetime] NULL,
	[NATIVE_PLACE] [nvarchar]  (25)  COLLATE Chinese_PRC_CI_AS  NULL ,
        [SCHOOL_AGE] [nvarchar]  (4)  COLLATE Chinese_PRC_CI_AS  NULL ,
        [MAJOR] [nvarchar]  (15)  COLLATE Chinese_PRC_CI_AS  NULL ,
        [GRADUATE_SCH] [nvarchar]  (10)  COLLATE Chinese_PRC_CI_AS  NULL ,
        [POLITIC_STATUS] [nvarchar]  (5)  COLLATE Chinese_PRC_CI_AS  NULL ,
        [WORK_TIME] [datetime] NULL,
        [COME_TIME] [datetime] NULL,
        [LINK_PHONE] [nvarchar]  (14)  COLLATE Chinese_PRC_CI_AS  NULL ,
        [ADDRESS] [nvarchar]  (20)  COLLATE Chinese_PRC_CI_AS  NULL ,
        [PHOTO] [image] NULL ,
        [REMARK] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL 

) ON [PRIMARY];