|
Failure
|
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near '@VariantGroup'. 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) CREATE PROCEDURE dbo.Smith_CopyProductVariant @ProductID INT, @VariantGroup VARCHAR(50) AS BEGIN INSERT Smith_ProductVariant (ProductID,VariantGroup,VariantName,VariantDisplayType,VariantImage,PriceAdjustment,WeightAdjustment,SortOrder, PortalId,VariantRequired) SELECT @ProductID as 'ProductID', VariantGroup, VariantName, VariantDisplayType, VariantImage, PriceAdjustment, WeightAdjustment, SortOrder, PortalId, VariantRequired FROM Smith_ProductVariant where variantid = @VariantGroup
|