Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

MS SQL Server 2005 issues with my trigger statement...

Avatar of GlobaLevel
GlobaLevelFlag for United States of America asked on
Microsoft SQL Server 2005Microsoft SQL Server 2008SQL
2 Comments1 Solution241 ViewsLast Modified:
Can someone help please...

Im getting this error..

Msg 102, Level 15, State 1, Procedure test_Product_Change_To_Product, Line 76
Incorrect syntax near '@GL_ID'.

---

CREATE TRIGGER test_Product_Change_To_Product
ON temp_Product
--DECLARE @id int

AFTER INSERT, UPDATE, DELETE


As
   
    DECLARE @GL_ID nvarchar(max)
      DECLARE @WIT_ID nvarchar(max)      
      DECLARE @SPELL_CHECK nchar(10)      
      DECLARE @HTML_FORMAT nchar(10)      
      DECLARE @PARENT_COMP nvarchar(max)
      DECLARE @WEBSITE_TYPE nvarchar(max)
      DECLARE @SHOP_CART nvarchar(max)      
      DECLARE @EMAIL nvarchar(max)      
      DECLARE @DOMAIN nvarchar(max)      
      DECLARE @HOME_PAGE nvarchar(max)             
      DECLARE @CONTACT_PAGE nvarchar(max)
      DECLARE @PRODUCT_PAGE nvarchar(max)
      DECLARE @COMPARE_CHART nvarchar(max)
      DECLARE @PRODUCT_1 nvarchar(max)             
      DECLARE @PRODUCT_2 nvarchar(max)      
      DECLARE @PRODUCT_3 nvarchar(max)            
      DECLARE @PRODUCT_TRIAL nvarchar(max)
      DECLARE @OVERVIEW nvarchar(max)
      DECLARE @SUPPORT_CENTER nvarchar(max)
      DECLARE @USER_FORUM nvarchar(max)      
      DECLARE @UNINSTALL_UTILITY nvarchar(max)
      DECLARE @LICENSE_CENTER nvarchar(max)       
      DECLARE @ABOUT nvarchar(max)       
      DECLARE @BLOG nvarchar(max)       
      DECLARE @FAQ nvarchar(max)                  
      DECLARE @CAREERS  nvarchar(max)       
      DECLARE @PRODUCT_ITEM_1 nvarchar(max)
      DECLARE @PRODUCT_ITEM_2 nvarchar(max)      
      DECLARE @PRODUCT_ITEM_3 nvarchar(max)       
      DECLARE @CATEGORY_ID nvarchar(max)


SELECT       @GL_ID = GL_ID,      
       @WIT_ID  =  WIT_ID ,       
       @SPELL_CHECK  = SPELL_CHECK ,
       @HTML_FORMAT        =  HTML_FORMAT  ,       
       @PARENT_COMP  =  PARENT_COMP  ,
       @WEBSITE_TYPE = WEBSITE_TYPE  ,
       @SHOP_CART         =  SHOP_CART ,      
       @EMAIL   =  EMAIL  ,
       @DOMAIN   =  DOMAIN  ,
       @HOME_PAGE  =  HOME_PAGE  ,      
       @CONTACT_PAGE  =  CONTACT_PAGE ,
       @PRODUCT_PAGE  =  PRODUCT_PAGE  ,
       @COMPARE_CHART  =  COMPARE_CHART ,
       @PRODUCT_1  = PRODUCT_1 ,      
       @PRODUCT_2  =  PRODUCT_2 ,      
       @PRODUCT_3  =  PRODUCT_3 ,      
       @PRODUCT_TRIAL  =  PRODUCT_TRIAL ,
       @OVERVIEW   =  OVERVIEW ,      
       @SUPPORT_CENTER  =  SUPPORT_CENTER       ,
       @USER_FORUM   =  USER_FORUM  ,      
       @UNINSTALL_UTILITY  =  UNINSTALL_UTILITY  ,      
       @LICENSE_CENTER    = LICENSE_CENTER  ,      
       @ABOUT  =  ABOUT ,      
       @BLOG  =  BLOG  ,
       @FAQ   =  FAQ  ,
       @CAREERS   =  CAREERS ,
       @PRODUCT_ITEM_1  = PRODUCT_ITEM_1 ,
       @PRODUCT_ITEM_2 =  PRODUCT_ITEM_2  ,
       @PRODUCT_ITEM_3  =  PRODUCT_ITEM_3 ,
       @CATEGORY_ID   =  CATEGORY_ID
       
FROM INSERTED

 EXEC dbo.sp_test_stored_procedure(
@GL_ID ,                 
@WIT_ID  ,                
@SPELL_CHECK  ,       
@HTML_FORMAT  ,             
@PARENT_COMP ,        
@WEBSITE_TYPE ,       
@SHOP_CART ,              
@EMAIL ,              
@DOMAIN ,              
@HOME_PAGE,               
@CONTACT_PAGE ,       
@PRODUCT_PAGE  ,      
@COMPARE_CHART ,       
@PRODUCT_1 ,              
@PRODUCT_2,               
@PRODUCT_3 ,              
@PRODUCT_TRIAL ,       
@OVERVIEW ,              
@SUPPORT_CENTER  ,      
@USER_FORUM ,              
@UNINSTALL_UTILITY  ,      
@LICENSE_CENTER ,          
@ABOUT ,                 
@BLOG ,             
@FAQ  ,             
@CAREERS ,              
@PRODUCT_ITEM_1,        
@PRODUCT_ITEM_2 ,       
@PRODUCT_ITEM_3,        
@CATEGORY_ID
)        

END
GO