新建 文本文档.txt

主要介绍了sql的基础教程

use pubs
go

create database mydb1
on primary
(
 name = 'mydb1_pri',
 filename = 'c:\mydb1_pri.mdf',
 size = 10,
 maxsize = 50,
 filegrowth = 5
),

filegroup mydb1_fp1
( 
  name = 'mydb1_data',
filename = 'c:\mydb1_data.ndf',
size = 10,
maxsize = 20,
filegrowth = 2

)

log on

(
name = 'mydb1_log',
filename = 'c:\mydb1_log.ldf',
size = 10,
maxsize = 20,
filegrowth = 2
)
go

drop database mydb1