Sivakumar

Sivakumar

  • NA
  • 551
  • 217.4k

Print statement not displaying message

Sep 24 2015 3:22 AM
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.

Answers (6)