如何创建一个指定大小但不指定目录的数据库 默认的创建CREATE DATABASE NAME 中,是创建在默认位置,但没指定大小。如果CREATE DATABASE NAME ON()可以指定大小,但同事也必须指定位置。怎么样才能在默认位置指定大小呢? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 摘自联机丛书.USE master;GOIF DB_ID (N'Sales') IS NOT NULLDROP DATABASE Sales;GO-- Get the SQL Server data pathDECLARE @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 SalesON PRIMARY( NAME = SPri1_dat, FILENAME = '''+ @data_path + 'SPri1dat.mdf'', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 15% ),( NAME = SPri2_dat, FILENAME = '''+ @data_path + 'SPri2dt.ndf'', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 15% ),FILEGROUP SalesGroup1( NAME = SGrp1Fi1_dat, FILENAME = '''+ @data_path + 'SG1Fi1dt.ndf'', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 ),( NAME = SGrp1Fi2_dat, FILENAME = '''+ @data_path + 'SG1Fi2dt.ndf'', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 ),FILEGROUP SalesGroup2( NAME = SGrp2Fi1_dat, FILENAME = '''+ @data_path + 'SG2Fi1dt.ndf'', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 ),( NAME = SGrp2Fi2_dat, FILENAME = '''+ @data_path + 'SG2Fi2dt.ndf'', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 )LOG ON( NAME = Sales_log, FILENAME = '''+ @data_path + 'salelog.ldf'', SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB )');GO 一台机器上面同时按照2005,2008,TCPIP好像无法同时打开。。。 游标与触发器使用的问题,请老大解决。谢谢老大了! JOIN链接失败 大家看过来 求一条统计里程的SQL语句 求sql语句 求一多表条件连接查询 大力 邹建 四脚蛇 快来!! 数据库还原问题!!急急急~~~~~ 求一sql 感谢大力在短消息里的帮助,请大力进来领分 数据库即时点恢复 请问高手们一个问题,先谢谢了 !
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 PRIMARY
( NAME = SPri1_dat,
FILENAME = '''+ @data_path + 'SPri1dat.mdf'',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 15% ),
( NAME = SPri2_dat,
FILENAME = '''+ @data_path + 'SPri2dt.ndf'',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 15% ),
FILEGROUP SalesGroup1
( NAME = SGrp1Fi1_dat,
FILENAME = '''+ @data_path + 'SG1Fi1dt.ndf'',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 ),
( NAME = SGrp1Fi2_dat,
FILENAME = '''+ @data_path + 'SG1Fi2dt.ndf'',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 ),
FILEGROUP SalesGroup2
( NAME = SGrp2Fi1_dat,
FILENAME = '''+ @data_path + 'SG2Fi1dt.ndf'',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 ),
( NAME = SGrp2Fi2_dat,
FILENAME = '''+ @data_path + 'SG2Fi2dt.ndf'',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = Sales_log,
FILENAME = '''+ @data_path + 'salelog.ldf'',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )'
);
GO