Insert Value via Visual Expression by Passing the Parameter ADF

Question

How to Insert Value via Visual Expression by Passing the Parameter ADF.
I am looking for Update Statement -- Example Like : Update 'TableName' Set 'ColumnName' = 1234 where Id is null .

I want to Set the Value when I pass the Parameter 1234 during Run time , it will add there in Update Statement to set the value.

I am trying to Use this -> "Update LOG_SEC_IDENTIFIER_New Set FirmHubId = '{$FirmHubID}' where FirmHubId is Null"

Need Help on this in ADF -- @Nasreen Akter

Answer 1

Hi @Kunal Bhatia ,

Thank you for posting query in Microsoft Q&A Platform.

Use your UPDATE query expression as below.

"Update dbo.persons set gender = '" + $genderValue + "'"  

Kindly check below example where I used UPDATE query in post sql script which takes parameter as value. I ran this and worked good for me.

Hope this helps. Please let us know if any further queries. Thank you.

----------------

Please consider hitting Accept Answer. Accepted answers help community as well.