USE master; GO IF DB_ID (N'Sales') IS NOT NULL DROP DATABASE Sales; GO -- Get the SQL Server data path DECLARE @data_path nvarchar(256); SET @data_path = (SELECT SUBSTRING(physical_name, 1, CHARINDEX(N'master.mdf', LOWER(physical_name)) - 1) FROM master.sys.master_files WHERE database_id = 1 AND file_id = 1);-- execute the CREATE DATABASE statement EXECUTE ('CREATE DATABASE Sales ON ( NAME = Sales_dat, FILENAME = '''+ @data_path + 'saledat.mdf'', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 ) LOG ON ( NAME = Sales_log, FILENAME = '''+ @data_path + 'salelog.ldf'', SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB )' ); GOGO 查看MSDN帮助里面,create datebase里面有对应的选项,及例子
create database student --创建数据库student on (name = Student数据, --逻辑文件名student数据文件.mdf filename = 'F:\编程\数据库student\student数据文件.mdf' ) log on ( name = Student日志, --逻辑文件名student日志文件.ldffilename = 'F:\编程\数据库student\student日志文件.ldf' ) 哈哈,找到了,不错耶
参考一下
GO
IF DB_ID (N'Sales') IS NOT NULL
DROP DATABASE Sales;
GO
-- Get the SQL Server data path
DECLARE @data_path nvarchar(256);
SET @data_path = (SELECT SUBSTRING(physical_name, 1, CHARINDEX(N'master.mdf', LOWER(physical_name)) - 1)
FROM master.sys.master_files
WHERE database_id = 1 AND file_id = 1);-- execute the CREATE DATABASE statement
EXECUTE ('CREATE DATABASE Sales
ON
( NAME = Sales_dat,
FILENAME = '''+ @data_path + 'saledat.mdf'',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = Sales_log,
FILENAME = '''+ @data_path + 'salelog.ldf'',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )'
);
GOGO
查看MSDN帮助里面,create datebase里面有对应的选项,及例子
on
(name = Student数据, --逻辑文件名student数据文件.mdf
filename = 'F:\编程\数据库student\student数据文件.mdf'
)
log on
(
name = Student日志, --逻辑文件名student日志文件.ldffilename = 'F:\编程\数据库student\student日志文件.ldf'
) 哈哈,找到了,不错耶