hi,
This is my stored procedure :
USE [kiwi]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[uspAddMemberTeam]
@TeamID INT,
@MemberID INT,
@MemberRole TINYINT
AS BEGIN
SET NOCOUNT ON;
DECLARE @MemberLoginID INT;
select @MemberLoginID =[MemberLoginID] FROM [MemberLogin] WHERE MemberID=@MemberID;
INSERT INTO TeamMember(TeamID,MemberID,MemberRole,MemberJoinedDate,MemberLoginID)values(@TeamID,@MemberID,@MemberRole,GETUTCDATE(),@MemberLoginID);
Print 'Added success..';
END
When I execute this procedure not displaying Print statement.