Print statement not displaying message

Sivakumar

11y855

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.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Raja T11y ago
Hi,Above screen you can not pass the input values . you must pass input values like @tempID=1,@memberID=1,@memberRole=1 it will be work fine i hope.
0
Sivakumar11y ago
Ya its working but, when i execute stored procedure like this picture it will return 0.

its return a 0;
0
Lalit Raghav11y ago
i have create this and this is working fine

0
Sivakumar11y ago
No its not working
0
Lalit Raghav11y ago
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);
SET NOCOUNT off
Print 'Added success..';

END
0
Lalit Raghav11y ago
before print you have to set set Nocount off.

Th
0