SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[validateQuery](
@as_validationparam1 VARCHAR(20),
@as_validationparam2 VARCHAR(20),
@as_validationparam3 VARCHAR(20),
@as_validatedResult varchar(100) out
)
as
BEGIN
set @as_validatedResult ='result after validation'
END
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[callingQuery](
@as_callingQueryparam1 VARCHAR(20),
@as_callingQueryparam2 VARCHAR(20)
)
as
DECLARE @ds_result varchar(100)
BEGIN
EXEC validateQuery 'validationparam1Value','validationparam2Value','validationparam3Value' , @ds_result OUT
END