Cevap: [PAYLASIM] 2015 "KOPK" SOACS Server Files ( Sunucu Firmalarinin Verdiği ) POWER
GO
/****** Object: StoredProcedure [dbo].[ADD_PREM_USER] Script Date: 01/08/2017 13:09:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[ADD_PREM_USER]
@AccountID varchar(27),
@nType 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,@nType,@nDays,GETDATE());
RETURN
END
BEGIN
DELETE FROM PREMIUM_SERVICE where strAccountID = @AccountID
INSERT INTO PREMIUM_SERVICE VALUES (@AccountID,@nType,@nDays,GETDATE());
RETURN
END