新建 文本文档.txt

主要介绍了sql的基础教程

create database dbtest 
on primary 
(
	name =dbtest_pri,
	filename ='d:\dbtest_pri.mdf',
	size = 5,
	maxsize=20,
	filegrowth=1
),
filegroup myfg
(
	name=dbtest_dat1,
	filename ='d:\dbtest_dat1.ndf',
        size = 5,
	maxsize=20,
	filegrowth=1
),
(
	name='dbtest_dat2',
	filename='d:\dbtest_dat2.ndf',
        size = 5,
	maxsize=20,
	filegrowth=1
)
log on
(
	name=dbtest_log,
	filename='d:\datest_log.ldf',
        size = 5,
	maxsize=20,
	filegrowth=1
)
go