GO附近的语法不正确 [英] Incorrect Syntax near GO

问题描述

我有这个存储过程：

I have this stored procedure:

USE master
GO

Alter Procedure RenameInPhysicalDrive
@databaseName VARCHAR(500),
@physicalPath VARCHAR(500),
@logFilePath VARCHAR(500)
AS
BEGIN
DECLARE @MyQuery NVARCHAR(500) =''
SET @MyQuery =( 'CREATE DATABASE  '+' '+ @databaseName+' ON ( NAME= '+@databaseName+
',FILENAME='+ @physicalPath
+',SIZE=10,MAXSIZE=50,FILEGROWTH=5)
LOG ON (NAME=' +@databaseName+'_log'+',FILENAME='+@logFilePath
+',SIZE=5MB,MAXSIZE=25MB,FILEGROWTH=5MB)
GO' )
EXEC sp_executesql @MyQuery
END

它给出了错误GO附近的语法错误。

如何解决它？

It's giving error Incorrect Syntax error near GO .
How can i resolve it?

推荐答案

尝试删除GO 。我不认为你在动态查询中需要它。

Try removing the GO. I don't think you need it on a dynamic query.

这篇关于GO附近的语法不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！