question

KunalBhatia-2218 avatar image
1 Vote"
KunalBhatia-2218 asked ShaikMaheer-MSFT commented

Insert Value via Visual Expression by Passing the Parameter ADF

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

201117-image.png


azure-data-factory
image.png (23.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered ShaikMaheer-MSFT commented

Hi @KunalBhatia-2218 ,

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.
201872-image.png

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


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


image.png (289.2 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @KunalBhatia-2218 ,

Just checking in to see if the above answer helped. If this answers your query, do click 130616-image.png and upvote 130671-image.png for the same. And, if you have any further query do let us know.

0 Votes 0 ·