asked on

issue with stored procedure

I am getting this error with my stored procedure...

Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 20
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 65
Incorrect syntax near ','.
Msg 102, Level 15, State 1, Procedure sp_test_Product_Change_To_Product, Line 93
Incorrect syntax near ','.

-- ================================================
-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters
-- command (Ctrl-Shift-M) to fill in the parameter
-- values below.
--
-- This block of comments will not be included in
-- the definition of the procedure.
-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:            <Author,,Name>
-- Create date: <Create Date,,>
-- Description:      <Description,,>
-- =============================================

-- _+_+_+_+_+

--

-- WE ARE READING PARAMETERS INTO SPROC

CREATE PROCEDURE sp_test_Product_Change_To_Product
@wit_id nvarchar(max)
, @SPELL_CHECK varchar(10)
, @html_compliant varchar(10)
, @HOME_PAGE nvarchar(max)
, @CONTACT_PAGEnvarchar(max)
, @PRODUCT_PAGEnvarchar(max)
, @COMPARE_CHART nvarchar(max)
, @PRODUCT_1 nvarchar(max)
, @PRODUCT_2 nvarchar(max)
, @PRODUCT_3 nvarchar(max)
, @PRODUCT_TRIAL nvarchar(max)
, @OVERVIEW nvarchar(max)
, @SUPPORT_CENTER nvarchar(max)
, @USER_FORUM nvarchar(max)
, @UNINSTALL_UTILITY nvarchar(max)
, @BLOG nvarchar(max)
, @LICENSE_CENTER nvarchar(max)
, @ABOUT nvarchar(max)
, @BLOG nvarchar(max)
, @FAQ nvarchar(max)
, @CAREERS nvarchar(max)
, @PRODUCT_ITEM_1 nvarchar(max)
, @PRODUCT_ITEM_2 nvarchar(max)
, @PRODUCT_ITEM_3 nvarchar(max)
, @CATEGORY_ID nvarchar(max)

AS

BEGIN

ASKER CERTIFIED SOLUTION

Bhavesh Shah

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Forefront_Data_Solutions

Please check that you have put a space before "nvarchar(max)" in the following lines:

, @CONTACT_PAGEnvarchar(max)
, @PRODUCT_PAGEnvarchar(max)

devlab2012

There are three errors:

1. No space between parameter name and data type in @CONTACT_PAGEnvarchar(max).
2. No space between parameter name and data type in @PRODUCT_PAGEnvarchar(max) .
3. @BLOG is declared twice.

so above posted code should be changed to :

CREATE PROCEDURE sp_test_Product_Change_To_Product 
   @wit_id nvarchar(max) 
 , @SPELL_CHECK varchar(10)
 , @html_compliant varchar(10) 
 , @HOME_PAGE  nvarchar(max)   
 , @CONTACT_PAGE nvarchar(max) 
 , @PRODUCT_PAGE nvarchar(max)  
 , @COMPARE_CHART nvarchar(max) 
 , @PRODUCT_1 nvarchar(max) 
 , @PRODUCT_2 nvarchar(max)                          
 , @PRODUCT_3 nvarchar(max) 
 , @PRODUCT_TRIAL nvarchar(max) 
 , @OVERVIEW nvarchar(max) 
 , @SUPPORT_CENTER nvarchar(max) 
 , @USER_FORUM nvarchar(max) 
 , @UNINSTALL_UTILITY nvarchar(max) 
 , @BLOG nvarchar(max) 
 , @LICENSE_CENTER nvarchar(max) 
 , @ABOUT nvarchar(max)       
 , @FAQ nvarchar(max)                  
 , @CAREERS  nvarchar(max)       
 , @PRODUCT_ITEM_1 nvarchar(max)
 , @PRODUCT_ITEM_2 nvarchar(max)      
 , @PRODUCT_ITEM_3 nvarchar(max)       
 , @CATEGORY_ID nvarchar(max)
       
AS    

BEGIN

Open in new window