hrsys.sql

开发人力资源管理系统的目的就是帮助企业的人力资源部门提高工作效率,实现企业认识信息管理的系统化,规范化和自动化.根据这个系统所要实现的目的和任务,总结出这个系统最终实现的主要功能如下: 1.部门信息

USE master
GO
CREATE DATABASE HrSys 
ON
PRIMARY ( NAME = Hr1,
      FILENAME = 'c:\program files\microsoft sql server\mssql\data\HrData1.mdf',
      SIZE = 100MB,
      MAXSIZE = 200,
      FILEGROWTH = 20),
( NAME = Hr2,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\HrData2.ndf',
   SIZE = 100MB,
   MAXSIZE = 200,
   FILEGROWTH = 20),
( NAME = Hr3,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\HrData3.ndf',
   SIZE = 100MB,
   MAXSIZE = 200,
   FILEGROWTH = 20)
LOG ON 
( NAME = HrLog1,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\HrLog1.ldf',
   SIZE = 100MB,
   MAXSIZE = 200,
   FILEGROWTH = 20),
( NAME = HrLog2,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\HrLog2.ldf',
   SIZE = 100MB,
   MAXSIZE = 200,
   FILEGROWTH = 20)
GO