DECLARE @DataFilePath AS NVARCHAR(MAX)

SET @DataFilePath = N'C:\ProgramData\Gemcom\'

DECLARE @LogFilePath AS NVARCHAR(MAX)

SET @DataFilePath = N'C:\ProgramData\Gemcom\'


USE master
Go
CREATE DATABASE TestDB
ON 
PRIMARY 
( NAME = N'TestDB_Data',FILENAME = @DataFilePath )
LOG ON 
( NAME = N'TestDB_Log',FILENAME = @LogFilePath  )

GO

不幸的是,这不起作用.当我尝试在sql Server Management Studio中运行它时,我收到了错误

Incorrect Syntax near
‘@DataFilePath’.

我想知道我打算做什么甚至是可能的？

谢谢