【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了272.sql相关资料,希望对各位网友有所帮助!
Create database DB_SQL
On Primary
( Name=DB_SQL_data,
Filename='E:\sql\DB_SQL_data.mdf',
Size=3,
Maxsize=30,
Filegrowth=3 ),
Filegroup group1
( Name=DB_SQL_data1,
Filename='E:\DB_SQL_data1.ndf',
Size=2MB,
Maxsize=20MB,
Filegrowth=25% ),
Filegroup group2
( Name=DB_SQL_data2,
Filename='E:\
sql\DB_SQL_data2.ndf',
Size=4,
Maxsize=40,
Filegrowth=4 )
Log on
( Name=DB_SQL_log1,
Filename='E:\sql\DB_SQL_log1.ldf',
Size=5,
Maxsize=50,
Filegrowth=5 ),
( Name=DB_SQL_log2,
Filename='E:\sql\DB_SQL_log2.ldf',
Size=6,
Maxsize=60,
Filegrowth=30% )
GO