How to return a statements in stored procedure

Question

Hi

 

 This is my procedure :

 

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[uspChangeMemberRole]

@TeamID INT,

@MemberID INT,

@MemberRole TINYINT
AS BEGIN

SET NOCOUNT ON;

UPDATE [dbo].[TeamMember] SET MemberRole=@MemberRole WHERE TeamID=@TeamID AND MemberID=@MemberID;
return @MemberRole;

End


When I Execute this procedure i want to return MemberRole Successfully Changed.

 

Please give me a solution how to return