SQL Server 2008程序设计案例集锦》-周峰-源代码和素材.rar

创建数据库： create database db_sqldata create database Mydatabase1 on ( name= Mydatabase1_data, filename='e:\mydata\Mydatabase1_data.mdf', size=4, maxsize=10, filegrowth=10% ) log on ( name= Mydatabase1_log, filename='e:\mydata\Mydatabase1_log.ldf', size=1, maxsize=6, filegrowth=1 ) create database Mydatabase2 on ( name=Mydatabase21_data, filename='e:\mydata\Mydatabase21_data.mdf', size=4, maxsize=10, filegrowth=10% ), ( name=Mydatabase22_data, filename='e:\mydata\Mydatabase22_data.mdf', size=3, maxsize=10, filegrowth=1 ) log on ( name=Mydatabase21_log, filename='e:\mydata\Mydatabase21_log.ldf', size=1, maxsize=6, filegrowth=1 ), ( name=Mydatabase22_log, filename='e:\mydata\Mydatabase22_log.ldf', size=1, maxsize=6, filegrowth=10% ) create database Mydatabase3 on primary ( name=Mydatabase31_data, filename='e:\mydata\Mydatabase31_data.mdf', size=4, maxsize=10, filegrowth=10% ), filegroup newgroup1 ( name=Mydatabase32_data, filename='e:\mydata\Mydatabase32_data.mdf', size=3, maxsize=10, filegrowth=1 ) log on ( name=Mydatabase31_log, filename='e:\mydata\Mydatabase31_log.ldf', size=1, maxsize=6, filegrowth=1 )