SQL基础教程上的一些源码

源代码在线查看: 创建customers数据库示例.sql

软件大小: 31 K
上传用户: zh64077118
关键词: SQL 基础教程 源码
下载地址: 免注册下载 普通下载 VIP

相关代码

				CREATE DATABASE Customers 
				ON PRIMARY 
				(
				   NAME = Customers,
					   FILENAME = 'C:\Program Files\Microsoft SQL Server\ MSSQL.1\MSSQL\DATA\ Customers.mdf',
					SIZE = 10, 
					MAXSIZE = UNLIMITED, 
					FILEGROWTH = 2
				),
				FILEGROUP DefaultGroup
				( 
					NAME = Customers_1, 
				FILENAME = 'C:\Program Files\Microsoft SQL Server\ MSSQL.1\ MSSQL\DATA\ Customers_1.ndf', 
					SIZE = 3MB, 
					MAXSIZE = UNLIMITED, 
					FILEGROWTH = 1MB
				)
				LOG ON 
				( 
					NAME = Customers_log, 
					FILENAME = 'D:\DataBaseLog \Customers_log.ldf', 
					SIZE = 1MB, 
					MAXSIZE = UNLIMITED, 
					FILEGROWTH = 10% 
				),
				( 
					NAME = Customers_log1, 
					FILENAME = 'D:\DataBaseLog\Customers_log1.ldf', 
					SIZE =3MB, 
					MAXSIZE = UNLIMITED, 
					FILEGROWTH = 10% 
				)			

相关资源