创建数据库
create database t1111
on primary
(name=‘t111’,
filename=‘E:\data\t111.mdf’, //路径
size=10mb,
maxsize=100mb,
filegrowth=10mb)
开启日志文件
log on
(name=‘t111_log’,
filename=‘E:\data\t111_log.ldf’,
size=10mb,
maxsize=100mb,
filegrowth=5mb)
扩展
use t111
alter database t111
modify file (
name=‘t111’,
maxsize=25mb,
filegrowth=10mb)
辅助文件
alter database t111
add file (
name=‘111.ndf’,
filename=‘E:\data\t111.ndf’,
size=10mb)
添加辅助日志文件:
alter database 数据库名
add log file
(
name=‘逻辑名’,
filename=‘路径\物理文件名.ldf’
)
收缩数据库文件
use t111
dbcc shrinkfile (N’t111’)
go
分离数据库(就是把这个脱机 )
use master
exec master.dbo.sp_detach_db @dbname=N’t111’
附件
create database t111
on
(filename=N’E:\data\t111.mdf’),
(filename=N’E:\data\t111_log.ldf’)
for attach
use t111
create table biao1
(id char (8),
name char(8),unique
sex char(2) default ‘男’,
jg varchar (12))
go
insert into biao1 values
(1,’'xxx,‘男’,‘山东’)
go
insert into biao1 values
(2,‘xxx’,‘男’,‘大日本帝国’)
go
insert into biao1 values
(3,‘xxx’,‘男’,‘山西’)
go
insert into biao1 values
(4,‘xxx’,‘男’,‘山西’)
go
insert into biao1 values
(5,‘xxx’,‘男’,‘山西’)
go
insert into biao1 values
(6,'xxx,‘男’,‘山东’)
go
insert into biao1 values
(7,‘xxx’,‘男’,‘河北’)
go
insert into biao1 values
(8,‘xxx’,‘男’,‘河北’)
select * from biao1
单表
create table biao1
(id int primary key,
name char(8) unique,
age int check (age>=18 and age<=30),
sex char(2) check(sex=‘男’ or sex=‘女’),
jiguan varchar(20) not null,
gongzi money,
zhiwei varchar (20)
exec sp_help biao1 查看表1的结构
批量往表里添加信息
select*from biao1 //查询所有
select biao1.name from biao1 where age=18 //查询表1中年龄为18name的所有