stocks.sql

用ｖｂ编的一个商品库存管理系统

USE master
GO
CREATE DATABASE Stocks
ON
PRIMARY ( NAME = Stock1,
      FILENAME = 'c:\program files\microsoft sql server\mssql\data\StockData1.mdf',
      SIZE = 10MB,
      MAXSIZE = 200,
      FILEGROWTH = 2),
( NAME = Stock2,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\StockData2.ndf',
   SIZE = 10MB,
   MAXSIZE = 200,
   FILEGROWTH = 2),
( NAME = Stock3,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\StockData3.ndf',
   SIZE = 10MB,
   MAXSIZE = 200,
   FILEGROWTH = 2)
LOG ON 
( NAME = StockLog1,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\StockLog1.ldf',
   SIZE = 1MB,
   MAXSIZE = 20,
   FILEGROWTH = 1),
( NAME = StockLog2,
   FILENAME = 'c:\program files\microsoft sql server\mssql\data\StockLog2.ldf',
   SIZE = 1MB,
   MAXSIZE = 2,
   FILEGROWTH = 1)
GO