bookmanage.sql

来自「在VB中开发的连接SQL的图书管理系统。」· SQL 代码 · 共 31 行

USE master
GO
CREATE DATABASE BookManage
ON
PRIMARY ( NAME = Bm1,
      FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\BmData1.mdf',
      SIZE = 10MB,
      MAXSIZE = 200,
      FILEGROWTH = 2),
( NAME = Bm2,
   FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\BmData2.ndf',
   SIZE = 10MB,
   MAXSIZE = 200,
   FILEGROWTH = 2),
( NAME = Bm3,
   FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\BmData3.ndf',
   SIZE = 10MB,
   MAXSIZE = 200,
   FILEGROWTH = 2)
LOG ON 
( NAME = BmLog1,
   FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\BmLog1.ldf',
   SIZE = 1MB,
   MAXSIZE = 20,
   FILEGROWTH = 1),
( NAME = BmLog2,
   FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\BmLog2.ldf',
   SIZE = 1MB,
   MAXSIZE = 20,
   FILEGROWTH = 1)
GO