I have the following SP :
USE [gestionriesgo]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[SpCambioPass]
@userLogin varchar(30),
@pass varchar(80),
@salt varchar(80)
as
begin
update userRegister
set pass = @pass, salt = @salt
where userLogin = @userLogin
end
and if it affects more than one row, it returns a variable that says exitoso
otherwise it says Error al actualizar
, but I have no idea how to do it