create database MySchool
on
(
name='MySchool',
filename='c:\data\MySchool.mdf',
size=10mb,
filegrowth=10%
)
log on
(
name='MySchool_log.ldf',
filename='c:\data\MySchool_log.ldf',
size=1mb,
maxsize=10mb
)
use MySchool
create table Students
(
ID int,
Name varchar(255),
Sex varchar(4),
Age int,
Nation varchar(20),
Phone varchar(14)
)
insert into Students values('1','李三','男','27','汉','12332112244')
insert into Students values('2','张思','女','72','汉','12777337778')
insert into Students values('3','张思','女','28','汉','12777337778')
select * from Students
update Students set Name='王思' where ID=3
drop table Students
drop database Myschool
TEST:
create database studb
on
(
/*数据文件的属性*/
name='testdb',
filename='C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\testdb.mdf',
size=10mb, --主数据文件的初始大小
maxsize=100mb, --主数据文件增长的最大值
filegrowth=15% --主文件的增长率
)
log on
(
/*日志文件的属性，各参数含义同上*/
name='testdb_log',
filename='C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\testdb.ldf',
size=1mb,
maxsize=20mb
)
