34,576
社区成员
发帖
与我相关
我的任务
分享
--调整一下
declare @s varchar(1000) --再定义一个变量
set @s = 'CREATE DATABASE TestDB
ON
(
NAME='+@LogicalFileName+',
FILENAME='+@PhysicalDataFileLocation+',
SIZE=20,
MAXSIZE=40,
FILEGROWTH=1
)
LOG ON
(
NAME='+@LogicalFileName_Log +'
FILENAME=@PhysicalLogDataFileLocation,
SIZE=5,
MAXSIZE=10,
FILEGROWTH=1
)
'
exec(@s)
--pring(@s) --如果执行出错,把它打印出来,然后放到查询分析器里编译一下,看是哪的问题
EXEC('CREATE DATABASE TestDB
ON
(
NAME='+@LogicalFileName+',
FILENAME='+@PhysicalDataFileLocation+',
SIZE=20,
MAXSIZE=40,
FILEGROWTH=1
)
LOG ON
(
NAME='+@LogicalFileName_Log +'
FILENAME=@PhysicalLogDataFileLocation,
SIZE=5,
MAXSIZE=10,
FILEGROWTH=1
)
')