• HyperFilter | DoS Protection | DDoS Protection | DoS Mitigation | DDoS Mitigation | AntiDoS | AntiDDoS | Proxy Shielding

SOACS PREMiUM - CASH KIRDIRMA [ EVT - PROSEDUR ]

Cevap: SOACS PREMiUM - CASH KIRDIRMA [ EVT - PROSEDUR ]



Kod:
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



Prosedür hatalı ntype kabul etmiyor typede kabul etmiyor rica etsem düzeltirmisiniz
 
Cevap: SOACS PREMiUM - CASH KIRDIRMA [ EVT - PROSEDUR ]



Knka Senin add_prem ide şöyle bi hata alıyom nedendir



Kod:
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'.
 
Geri
Üst