config.usp_parameter_set - P

CREATE Procedure [config].[usp_parameter_set]
(
    @Parameter_name  Varchar(100)
  , @sub_Parameter   NVarchar(128) = ''
  , @Parameter_value NVarchar(Max)
)
As
--
Update
    p
Set
    Parameter_value = @Parameter_value
From
    [config].Parameter p
Where
    p.Parameter_name    = @Parameter_name
    And p.sub_Parameter = @sub_Parameter;

--IF NOT EXISTS
--(
--    SELECT
--           [col]
--    FROM
--         [repo].[Parameter] AS p
--    WHERE  [p].[Parameter_name] = @Parameter_name
--           AND [p].[sub_Parameter] = @sub_Parameter
--)
Insert Into [config].Parameter
(
    Parameter_name
  , sub_Parameter
  , Parameter_value
)
Select
    @Parameter_name
  , @sub_Parameter
  , @Parameter_value
Where
    Not Exists
(
    Select
        1
    From
        [config].Parameter As p
    Where
        p.Parameter_name    = @Parameter_name
        And p.sub_Parameter = @sub_Parameter
);

sqlCopied!