stumana.txt

来自「用vb做一个学生管理系统（数据库sql）」· 文本 代码 · 共 32 行

USE master
GO
CREATE DATABASE StuMana
ON
PRIMARY ( NAME = St1,
      FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\StMaData1.mdf',
      SIZE = 10MB,
      MAXSIZE = 200,
      FILEGROWTH = 2),
( NAME = St2,
   FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\StMaData2.ndf',
   SIZE = 10MB,
   MAXSIZE = 200,
   FILEGROWTH = 2),
( NAME = St3,
   FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\StMaData3.ndf',
   SIZE = 10MB,
   MAXSIZE = 200,
   FILEGROWTH = 2)
LOG ON 
( NAME = StLog1,
   FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\StMaLog1.ldf',
   SIZE = 1MB,
   MAXSIZE = 20,
   FILEGROWTH = 1),
( NAME = StLog2,
   FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\StMaLog2.ldf',
   SIZE = 1MB,
   MAXSIZE = 20,
   FILEGROWTH = 1)
GO