7-03.sql

来自「包括本书所有的源代码。所有程序均在Windows 2000+IIS5.0+SQL」· SQL 代码 · 共 30 行

SQL
30
字号
CREATE DATABASE Archive 
ON
PRIMARY ( NAME = Arch1,
      FILENAME = 'c:\program files\microsoft sql server\mssql\data\archdat1. mdf',
      SIZE = 1MB,
      MAXSIZE =1,
      FILEGROWTH = 1),
( NAME = Arch2,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\archdat2.ndf',
   SIZE = 1MB,
   MAXSIZE = 1,
   FILEGROWTH = 1),
( NAME = Arch3,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\archdat3.ndf',
   SIZE = 1MB,
   MAXSIZE = 1,
   FILEGROWTH = 1)
LOG ON 
( NAME = Archlog1,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\archlog1.ldf',
   SIZE = 1MB,
   MAXSIZE = 1,
   FILEGROWTH =1),
( NAME = Archlog2,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\archlog2.ldf',
   SIZE = 1MB,
   MAXSIZE = 1,
   FILEGROWTH =1)
GO

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?