Stored Procedures [dbo].[git_baseline_update]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@P_BASELINE_NAMEnvarchar(100)200
@P_ATTRIBUTE_NAMEnvarchar(100)200
Permissions
TypeActionOwning Principal
GrantExecuteaiadmin
SQL Script
Create PROCEDURE git_baseline_update (@P_BASELINE_NAME  NVARCHAR(100),
                              @P_ATTRIBUTE_NAME NVARCHAR(100))
AS
BEGIN
    INSERT INTO ai_baseline_attribute_info(attribute_uuid,
    column_name ,
    attribute_type ,
    attribute_format,
    attribute_value_text ,
    attribute_value_long ,
    attribute_value_double )

    select    TOP 1 baseline_info.baseline_attrib_uuid,
            @P_ATTRIBUTE_NAME,
            3,
            300,
            NULL,
            NULL,
            10
    from ai_baseline_info as baseline_info
    INNER JOIN  ai_baseline as baseline ON baseline.baseline_uuid = baseline_info.baseline_uuid
    where baseline.baseline_name = @P_BASELINE_NAME
    AND NOT EXISTS
    (select * from ai_baseline_attribute_info where ai_baseline_attribute_info.attribute_uuid = baseline_info.baseline_attrib_uuid)    

END
GO
GRANT EXECUTE ON  [dbo].[git_baseline_update] TO [aiadmin]
GO
Uses