Insert update asset Sample

DECLARE @return_value int,
        @assetId uniqueidentifier


-- insert or update asset
EXEC    @return_value = [dbo].[proc_insert_update_asset_from_ES]
        @assetId = @assetId OUTPUT,
        @externalSystemConfigurationId = 'D964933C-2717-4CF2-BB03-FFC27C974136',
        @assetCode = N'AHU-1-11',
        @assetName = N'Air Handling Unit (1)',
        @assetDescription = N'Air Handling Unit',
        @assetType = N'High Airflow 3',
        @assetSystem = N'AC',
        @assetSerialNumber = N'871246983240986',
        @assetModelNumber = N'Alpha-AHU',
        @assetWarantyStartDate = N'2014-12-16 00:00:00.000',
        @assetPurchasingCost = N'1400',
        @assetRepacmentCost = N'1600',
        @assetConditionType = N'2',
        @assetTagNumber = N'AHU',
        @assetBarCode = N'39123439',
        @assetManufacturer = N'Air Change',
        @assetLocation = N'OR Club Plant Room '

-- insert or update attributes
EXEC proc_update_asset_attribute_from_ES
    @assetId =@assetId,
    @assetAttributeName = 'Asset_Drawing',
    @assetAttributeValue = 'HBGFAHU10'

EXEC proc_update_asset_attribute_from_ES
    @assetId =@assetId,
    @assetAttributeName = 'One more attribute',
    @assetAttributeValue = 'some value'