|
Hi Lukezy
I am working on a custom update module for our web site that pulls stock from inventory system. This will create one custom field.
I then need to update this value using an update stored procedure. I have this t-sql which works in the query analyser
UPDATE dsc_product
SET customfields.modify('
replace value of (//ArrayOfCustomField/CustomField/Value/text()) [0]
with "TEST VALUE"')
WHERE productid = 21211
I am replicating the DSC_Product_Update stored procedure and modifying it to use the above code but I am unsure of how to pass a parameter @CustomFieldvalue for the value "TEST VALUE".
Can you help me with this?
|