使用SQL语句创建一个数据库,名字为mydb,数据文件名为: mydb_data.mdf...答:< filespec > [ ,...n ]eg.USE master GO CREATE DATABASE Mydb ON ( NAME = Mydb_dat,FILENAME = 'mydb_data.mdf',SIZE = 2,MAXSIZE = 50,FILEGROWTH = 5 )LOG ON ( NAME = 'Sales_log',FILENAME = 'mydblog.ldf',SIZE = 1MB,MAXSIZE = 25MB,FILEGROWTH = 1MB )GO ...
sql中创建一个数据库,要求创建两个数据文件,格式怎么写啊,用什么连接...答:create database Db on primary ---这里加primary (name=DB_data1,filename="d:\ceshi\DB_data1.mdf",size=5Mb,filegrowth=10%,maxsize=100Mb ),---这里加斗号 (name=DB_data2,filename="d:\ceshi\DB_data2.ndf",size=5Mb,filegrowth=10%,maxsize=100Mb )log on (name=DB_log,...