Sql Server 入门

下载SqlServer

下载SqlServer管理器: SQL Server Managemen Studio

T_sql语句

作用对sql sever数据库进行DDL DCL DML操作

在d盘database文件（需提前创建且不是源数据库位置）中创建数据库

create database MyFristDb
on
(
NAME=MyFirstDb,
FileName= 'D:\database\MyFirstDb.mdf',
Size=5mb,
MaxSize=unlimited,
FileGrowth=5%
)

LOG
ON
(
NAME=MyFirstDb_log,
FileName= 'D:\database\MyFirstDb.ldf',
Size=5mb,
MaxSize=60mb,
FileGrowth=5%
)