📄 studentsys.sql
字号:
USE master
GO
CREATE DATABASE StudentSys
ON
PRIMARY ( NAME = St1,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\StData1.mdf',
SIZE = 10MB,
MAXSIZE = 200,
FILEGROWTH = 2),
( NAME = St2,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\StData2.ndf',
SIZE = 10MB,
MAXSIZE = 200,
FILEGROWTH = 2),
( NAME = St3,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\StData3.ndf',
SIZE = 10MB,
MAXSIZE = 200,
FILEGROWTH = 2)
LOG ON
( NAME = StLog1,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\StLog1.ldf',
SIZE = 1MB,
MAXSIZE = 20,
FILEGROWTH = 1),
( NAME = StLog2,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\StLog2.ldf',
SIZE = 1MB,
MAXSIZE = 20,
FILEGROWTH = 1)
GO
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -