hello i want to insert new update table in story procedure but when i execute appear this error:
Msg 156, Level 15, State 1, Procedure TT_IGScore, Line 14
Incorrect syntax near the keyword 'ELSE'.
This is my store procedure:
USE [Ranking]
GO
/****** Object: StoredProcedure [dbo].[TT_IGScore] Script Date: 12/08/2012 16:24:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[TT_IGScore]
@ServerCode INT,
@AccountID VARCHAR(10),
@Name VARCHAR(10),
@PlayDay TINYINT
As
Begin
BEGIN TRANSACTION
SET NOCOUNT ON
IF EXISTS (SELECT NULL FROM IMPERIALGUARDIAN_INFO WHERE Account = @AccountID AND Name = @Name AND ServerCode = @ServerCode AND PlayDay = @PlayDay)
UPDATE IMPERIALGUARDIAN_INFO SET WinCount = WinCount+1 WHERE Account = @AccountID AND Name = @Name AND ServerCode = @ServerCode AND PlayDay = @PlayDay
UPDATE MuOnline.dbo.Character SET reputation = reputation+1 WHERE AccountID = @AccountID AND Name = @Name
ELSE
INSERT INTO IMPERIALGUARDIAN_INFO (ServerCode, Account, Name, WinCount, PlayDay) VALUES (@ServerCode,@AccountID,@Name,1,@PlayDay)
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION
SET NOCOUNT OFF
End
where is WRONG?