I have a batch of SQL to install in my module and it gives a error during installation at this procedure
GO
create procedure {databaseOwner}[{objectQualifier}SoftFinity_Customers_DeleteCustomer]
@CustomerID int ,
@ModuleID int
as
Delete from {databaseOwner}[{objectQualifier}SoftFinity_Customers_Customers] where CustomerID=@CustomerID and ModuleID=@ModuleID
The error
System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'procedure'. Must declare the variable '@CustomerID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) GO create procedure dbo.[SoftFinity_Customers_DeleteCustomer] @CustomerID int , @ModuleID int as Delete from dbo.[SoftFinity_Customers_Customers] where CustomerID=@CustomerID and ModuleID=@ModuleID.
I haven't notice any sql error of the procedure above. Seems like it put "GO" statement on the same line with "create procedure" statement and then execute the query. It is executed fine if remove "GO" statement but I can't do this because it's batch of SQL.
Any suggestion?
thanks.