score:2

Accepted answer
ALTER PROCEDURE dbo.EditUserInfo
(
    @FirstName NVARCHAR(100),
    @LastName NVARCHAR(200),
    @UserName NVARCHAR(100),
    @Password BINARY = NULL
)
AS BEGIN

    SET NOCOUNT ON

    UPDATE dbo.UserAcount
    SET FirstName = @FirstName,
        LastName = @LastName,
        Password = ISNULL(@Password, Password)
    WHERE UserName = @UserName

END

score:3

You can just add "= NULL" after @password parameter.

alter procedure EditUserInfo
(@FirstName nvarchar(100),
@LastName nvarchar(200),
@UserName nvarchar(100),
@Password binary = NULL
)
as
begin
    if (@Password IS NULL)
        BEGIN
            UPDATE UserAcount
            SET 
                FirstName = @FirstName , 
                LastName = @LastName
            where UserName = @UserName
        END
    ELSE
        BEGIN
            UPDATE UserAcount
            SET 
                FirstName = @FirstName , 
                LastName = @LastName, 
                [Password] = @Password 
            where UserName = @UserName
        END
end

More questions

More questions with similar tag