GlobaLevel
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_Pro duct, Line 76
Incorrect syntax near '@GL_ID'.
---
CREATE TRIGGER test_Product_Change_To_Pro duct
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_procedu re(
@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
Im getting this error..
Msg 102, Level 15, State 1, Procedure test_Product_Change_To_Pro
Incorrect syntax near '@GL_ID'.
---
CREATE TRIGGER test_Product_Change_To_Pro
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_procedu
@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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER