sql stored procedure return value

Question

bonjour, when executing a stored procedure, i have got my result and a return value with 0, i know that 0 seem to be no error when executing, but, i dont wanted that.

return value 0

here is my code, where or how can i solve that please?

USE [Active]
GO
/****** Object:  StoredProcedure [dbo].[PS_BR_listeProjetUneEntreprise]Script Date: 11/04/2018 13:39:10 ******/
SET ANSI_NULLS ON
GO
 SET QUOTED_IDENTIFIER ON
GO
  -- =============================================
  -- Author:        BR
  -- Create date: 11/04/2018
  -- Description:   liste des projets d'une entreprise donnée
  -- =============================================
ALTER PROCEDURE [dbo].[PS_BR_listeProjetUneEntreprise] 
-- Add the parameters for the stored procedure here
@nomClient varchar(55)
AS
BEGIN
  -- SET NOCOUNT ON added to prevent extra result sets from
  -- interfering with SELECT statements.
  SET NOCOUNT ON;

  -- Insert statements for procedure here
  select [dbo].[PROJET].nomProjet, [dbo].[CLIENT].raisonSociale
  from [dbo].[PROJET]
  join [dbo].[CLIENT]
  on [dbo].[PROJET].idClient = [dbo].[CLIENT].idClient
  where [dbo].[CLIENT].raisonSociale like @nomClient
END

i am using sql server management studio 17

For returning single scalar values, don't use RETURN, use OUTPUT. "I don't want to" isn't a very technical reason to break convention. — Aaron Bertrand
– Aaron Bertrand, Commented Apr 11, 2018 at 12:02
Where are you seeing the return value that you don't want it? Please describe your problem better. Calling this procedure, as is, does not produce this Return Value column you're showing in SSMS. That must be coming from somewhere else. — Aaron Bertrand
– Aaron Bertrand, Commented Apr 11, 2018 at 12:02
You're screenshot is showing at least 3 columns but the stored procedure is only returning two. Are you looking at the wrong stored proc? — Mazhar
– Mazhar, Commented Apr 11, 2018 at 12:09

PSK · Accepted Answer · 2018-04-11 12:07:22Z

1

After looking at the output image, I feel like you are executing your SP using SSMS like below query.

USE [Active]
GO    
DECLARE @return_value INT
DECLARE @nomClient varchar(55) ='abc'    
EXECUTE @return_value = [dbo].[PS_BR_listeProjetUneEntreprise] @nomClient    
SELECT  @return_value

Above is the standard template used when you use generate script option for executing a SP.

You can run it without return value also like following.

USE [Active]
GO    
DECLARE @nomClient varchar(55) ='abc'
EXECUTE  [dbo].[PS_BR_listeProjetUneEntreprise] @nomClient

This way you will not get additional record.

answered Apr 11, 2018 at 12:07

PSK

18k5 gold badges35 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Romain Over a year ago

i will try, thanx you

Collectives™ on Stack Overflow

sql stored procedure return value

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related