set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGO-- =============================================-- Author: Test-- Create date: Test-- Description: Test-- =============================================ALTER PROCEDURE [dbo].[delnp] -- Add the parameters for the stored procedure here @p1 int = 0, @p2 int = 0, @p3 int = 0ASBEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here SELECT @p2 = IDNotaDePlata FROM dbo.NoteDePlata WHERE Stare=2 AND IDmasa=@p1 SELECT @p3 = Total FROM dbo.Incasari where IDNotaDePlata = @p2 RETURN @p3END