How to Pass Parameter in Database Activity

[Hemanth (Hemachandiran K)]

Hi Guys,
I need to Know how to pass parameter in Execute Non Query Database
Activity.
I tried lot and also i searched in different web sources but still i didn’t get feasible solution.

Here i am getting Error as updateValue is Not declared
But i am done initialization in Parameters panel.
If any one know the solution let me Know…
Thanks guys.

[vvaidya (Vinay Vaidya)]

I may be wrong, but I think SQL Parameters is for Stored Procedure Type.

For Text, you need to pass Local Variables only.

[Jishnu_Kumar]

Take data (unique IDs in a column) from excel and pass as parameters in SQL Query (Execute Query)

You can make use of Argument and local variable to achieve this. [image]

[KapilJain]

How to pass NULL parameter to variable type as String into Database

[pari_patel]

Hey,
On Stored procedure I have 3 account numbers fetching records. If I want to use only 1 account number records, How should I pass parameters on SQL execute procedure?