printing messages with a Stored Procedure

[triciameza]

Here is my SP:

Create PROCEDURE [dbo].[update_email]
(
@customerid as numeric(10),
@oldemail as varchar(50),
@newemail as varchar(50)
)
AS
BEGIN
update customerinfo
set email = @newemail
where @oldemail in (select email from customerinfo
where email = @oldemail)
and @customerid in (select customerid from customerinfo
where customerid = @customerid)
print 'Your email address has been updated'
end
begin
if @oldemail not in (select email from customerinfo
where email = @oldemail)
print 'Email not found'

END

My question is when I run this SP I receive both messages. I only want to receive one message. How do I make this work correctly, please help.

[almaz]

It looks like your query can be optimized.
Use this one:

Create PROCEDURE [dbo].[update_email]
(
@customerid as numeric(10),
@oldemail as varchar(50),
@newemail as varchar(50)
)
AS
BEGIN
    update customerinfo
    set email = @newemail
    where customerid = @customerid and email = @oldemail 
 
    IF @@ROWCOUNT<>0
        print 'Your email address has been updated'
    ELSE
        print 'Email not found'
END

[triciameza]

This works great, thank you very much.