㈠ 使用T-SQL創建人事管理資料庫
CREATE DATABASE [HrSys]
ON PRIMARY
( NAME = N'HrSys', FILENAME = N'D:\人事管理數據\HrSys.mdf' , SIZE = 3072KB , FILEGROWTH = 10%)
LOG ON
( NAME = N'HrSys_log', FILENAME = N'E:\人事管理日誌\HrSys_log.ldf' , SIZE = 1024KB , FILEGROWTH = 10%)
GO
Drop Database [HrSys]