34,576
社区成员
发帖
与我相关
我的任务
分享
Use Master
Go
If Exists (Select Name From Master.dbo.sysdatabases Where Name = N' <DatabaseName> ')
EXEC sp_detach_db [ <DatabaseName> ]
Go
declare @DatabaseName sysname,@DatabasePath nvarchar(4000)
select @DatabaseName='Test',@DatabasePath='C:\'
exec( '
Create Database ['+@DatabaseName+']
On
(Name = N'''+ @DatabaseName +'_dat'',
FILENAME = N'''+ @DatabasePath+@DatabaseName+'_Data.MDF'' ,
Size = 4,
FILEGROWTH = 10%)
Log On
(Name = N'''+ @DatabaseName+'_log'',
FILENAME = N'''+@DatabasePath + @DatabaseName+'_log.LDF'' ,
Size = 1,
FILEGROWTH = 10%)
Collate Chinese_PRC_CI_AS ')