如何在指定目录下创建数据库？
如
@dbname char(20)
set @dbname = 'xymis'
要把数据库建在d:\xymis\dbname
问题点数：50、回复次数：5Top
1 楼zlp321002（Life Is Good,Let's Shine）回复于 2005-11-22 19:24:49 得分 0
USE master
GO
CREATE DATABASE Sales
ON
( NAME = Sales_dat,
FILENAME = 'c:\program files\microsoft sql server\mssql\data\saledat.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'Sales_log',
FILENAME = 'c:\program files\microsoft sql server\mssql\data\salelog.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
GO
Top
2 楼zlp321002（Life Is Good,Let's Shine）回复于 2005-11-22 19:33:15 得分 0
--参考下，把参数传进去就可以了。Top
3 楼comszsoft（星星点灯）回复于 2005-11-22 22:50:24 得分 0
好像帮助里写的很清楚啊，建议楼主多看帮助
Top
4 楼weifai88（weifai88）回复于 2005-11-23 08:40:10 得分 0
大家可能没理解好，是这样：
@dbname 是变量
核心问题是如何把这个变量传给指定目录
如 d:\xymis\@dbnameTop
5 楼scmail81（琳·风の狼(修罗)）回复于 2005-11-23 14:35:44 得分 50
USE master
GO
DECLARE @T varchar(500)
DECLARE @T_SQL varchar(8000)
set @T='D:\Temp'
set @T_SQL='CREATE DATABASE Sales
ON
( NAME = Sales_dat,
FILENAME = ''' + @T + '\saledat.mdf'''+',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = Sales_log,
FILENAME = ''' +@T +'\salelog.ldf''' +',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )'
--print @T_SQL
exec (@T_SQL)Top
