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