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 @masa int = 0,ASBEGINDECLARE @id intDECLARE @total int -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here SELECT @id = IDNotaDePlata FROM dbo.NoteDePlata WHERE Stare=2 AND IDmasa = @masa SELECT @total = Total FROM dbo.Incasari where IDNotaDePlata = @id PRINT @totalEND