Link to home
Start Free TrialLog in
Avatar of GlobaLevel
GlobaLevelFlag for United States of America

asked on

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

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


 












ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of GlobaLevel

ASKER

Thank you angelIII !!!