CREATE PROCEDURE [dbo].[ADD_PREM_USER]
@AccountID varchar(27), [MENTION=617]nty[/MENTION]pe smallint,
@nDays smallint
AS
declare @ID varchar(27)
SELECT @ID = count(strAccountID) FROM PREMIUM_SERVICE where strAccountID = @AccountID
IF @ID = 0
BEGIN
INSERT INTO PREMIUM_SERVICE VALUES (@AccountID [MENTION=617]nty[/MENTION]pe,@nDays,GETDATE());
RETURN
END
BEGIN
DELETE FROM PREMIUM_SERVICE where strAccountID = @AccountID
INSERT INTO PREMIUM_SERVICE VALUES (@AccountID [MENTION=617]nty[/MENTION]pe,@nDays,GETDATE());
RETURN
END
GO
Server: Msg 170, Level 15, State 1, Procedure ADD_PREM_USER, Line 2
Line 2: Incorrect syntax near 'MENTION=617'.
Server: Msg 170, Level 15, State 1, Procedure ADD_PREM_USER, Line 9
Line 9: Incorrect syntax near 'MENTION=617'.
Server: Msg 170, Level 15, State 1, Procedure ADD_PREM_USER, Line 14
Line 14: Incorrect syntax near 'MENTION=617'.