7-02.sql

来自「asp开发 asp开发 asp开发 asp开发」· SQL 代码 · 共 15 行

CREATE DATABASE MySales
ON 
( NAME = Sales_dat,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\Mysaledat.mdf',
   SIZE = 2,
   MAXSIZE = 2,
   FILEGROWTH = 2 )
LOG ON
( NAME = 'Sales_log',
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\Mysalelog. ldf',
   SIZE = 1MB,
   MAXSIZE = 1MB,
   FILEGROWTH = 1MB )
GO