哪里错了？将数据库创建到指定目录的问题。

[xiaohefeng]

我用以下语句创建一个数据库，但报错（@path1附近语法错误)，请问哪里错了？谢谢！
declare @path varchar(200)
declare @path1 varchar(200)
declare @path2 varchar(200)
select @path = filename from master.dbo.sysfiles
set @path = ltrim(REVERSE(@path))
set @path1 = REVERSE(substring(@path,CHARINDEX('\',@path),len(@path))) +'zcgl2.mdf'
set @path2 = REVERSE(substring(@path,CHARINDEX('\',@path),len(@path))) +'zcgl2_log.LDF'


CREATE DATABASE [zcgl2] ON (NAME = N'zcgl2', FILENAME = @path1 , SIZE = 1, FILEGROWTH = 5%)
LOG ON (NAME = N'zcgl2_log', FILENAME = @path2, FILEGROWTH = 10%)
COLLATE Chinese_PRC_CI_AS
GO

[Chiff]

此处不能用变量

declare @path varchar(200)
declare @path1 varchar(200)
declare @path2 varchar(200)
select @path = filename from master.dbo.sysfiles
set @path = ltrim(REVERSE(@path))
set @path1 = REVERSE(substring(@path,CHARINDEX('\',@path),len(@path))) +'zcgl2.mdf'
set @path2 = REVERSE(substring(@path,CHARINDEX('\',@path),len(@path))) +'zcgl2_log.LDF'


declare @sql nvarchar(4000)

set @sql = '
CREATE DATABASE [zcgl2] ON (NAME = N''zcgl2'', FILENAME = ''' + @path1 + ''' , SIZE = 1, FILEGROWTH = 5%)
LOG ON (NAME = N''zcgl2_log'', FILENAME = ''' + @path2 + ''', FILEGROWTH = 10%)
COLLATE Chinese_PRC_CI_AS
'

exec(@sql)