📄 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
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -