CREATE PROCEDURE [dbo].[UpdateAccountPassword]
    @AccountPwd varchar(255),
    @Email varchar(255)
AS
BEGIN
    SET NOCOUNT ON;
		
		DECLARE @Result varchar(20)
    DECLARE @AccountExists int;
		
		BEGIN TRY
		BEGIN TRANSACTION

    SELECT @AccountExists = COUNT(*) FROM AccountTable
    WHERE Email = @Email;


-- Check if account exists
         IF @AccountExists > 0
        SET @Result = 'AccountExists';
        ELSE 
        SET @Result = 'Failed';

    -- Update password
    IF @Result = 'AccountExists' 
    BEGIN
        UPDATE AccountTable SET AccountPwd = @AccountPwd
WHERE Email = @Email;
		
		SET @Result = 'PasswordChanged';

END;

COMMIT TRANSACTION;
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION;
SET @Result = 'TransactionFailed';
END CATCH

SELECT @Result as Result;

END